KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have sort of a bizarre issue here attempting to use COUNTIF . pretend for a moment this is the sheet in question: A B John Doe John Smith John The last value there (B3) is an empty field. The intended COUNTIF formula should count the number of empty values in the B column only IF John is present in the A column. The only way I have been able to do this successfully is explicitly specifying the range to be counted ( B1:B3 ), but this formula is going to be doing this on multiple sheets that do not all have the same number of rows, therefore, I cannot use COUNTBLANK because it is returning staggeringly high results if I simply name the B column a name and specify the name as the range. EDIT: So apparently countif cannot be used for that? A workaround I have found is using SUMPRODUCT . Is this the best way to go about doing this? =SUMPRODUCT((September!K1:K16000="John")*(September!L1:L16000=""))
Tags (comma-separated)
Save Edits
Cancel