CountIF logic if one column has values and the other is blank?

Jonathan Korengold

Can someone point me in the right direction to count testing scenario rows if the Status column is blank but the Tested By column contains a value? Have played around with COUNTIF and using <>"" as well is ISBLANK but can't seem to get it exactly right.

Thanks in advance!!!

Mike TV

@Jonathan Korengold

=COUNTIFS(Status:Status, ISBLANK(@cell), [Tested By]:[Tested By], NOT(ISBLANK(@cell)))

Jonathan Korengold

@Mike TV

=COUNTIFS([Pass/Fail]19:[Pass/Fail]168, ISBLANK([@cell), [Tested By]19:[Tested By]168, NOT(ISBLANK(@cell)))

Tried this with actual column names and ranges entered, still not working.

Genevieve P.

Hi @Jonathan Korengold

Your first ISBLANK has an accidental [ in with the @cell:

 ISBLANK([@cell)

Try removing that 🙂

=COUNTIFS([Pass/Fail]19:[Pass/Fail]168, ISBLANK(@cell), [Tested By]19:[Tested By]168, NOT(ISBLANK(@cell)))

Jonathan Korengold

@Genevieve P. Thanks, but even after fixing that typo it's still #UNPARSEABLE

Genevieve P.

Hi @Jonathan Korengold

Can you post a screen capture of the formula open in the cell?

Jonathan Korengold

Genevieve P.

Thanks @Jonathan Korengold!

Can I clarify what it is exactly you're looking to do? It seems perhaps the ranges here are incorrect: do you have 168 rows on the sheet?

Right now, the formula is only counting rows between row 19 - 168. It also is not looking for any of the data you have listed in the column to the right. Are you looking for "In progress" or simply "blank" and "not blank"?

Try removing the row references to see if that helps with the error:

=COUNTIFS([Pass/Fail]:[Pass/Fail], ISBLANK(@cell), [Tested By]:[Tested By], NOT(ISBLANK(@cell)))

We'll also need to ensure that the column names are spelled exactly the same in your formula as they appear in the sheet. I can't quite see your column names in this screen capture, is it possible that one of them has slightly different formatting? (E.g. "Pass / Fail" versus "Pass/Fail")

Jonathan Korengold

Jonathan Korengold

@Genevieve P. Thanks for your help, we decided to go a different route but appreciate the prompt replies and engagement!