Countif blank or not.

Hi guys, so i am trying to think of how i can do this.. and if i can!

So for example, i want to count the blank cells in column H, but only if column B has text in it.

how would i do so?

Try:

=COUNTBLANK(H:H)-COUNTA(B:B)

That would give you the number of cells that are blank in both columns H and B. Is that what you're looking for? Your post is a little unclear.

Perhaps:

Formula:

Please Login or Register  to view this content.

BSB

Originally Posted by TFiske

Try:

=COUNTBLANK(H:H)-COUNTA(B:B)

That would give you the number of cells that are blank in both columns H and B. Is that what you're looking for? Your post is a little unclear.

Sorry, if column B1 has text in it then count H1 if H1 is blank

But if B2 is empty don’t count H2, if that makes sense!

But it has to count The whole H1:H50 for example doing as above!

Attach a sample workbook and show your desired outcome.

Make sure the data is representative of your real workbook but desensitized if appropriate.

BSB

Attached the workbook.

Try:

Formula:

Please Login or Register  to view this content.

BSB

Originally Posted by BadlySpelledBuoy

Try:

Formula:

Please Login or Register  to view this content.

BSB

Worked, thank you ☺️

Happy to help

BSB

New problem with it! its counting the empty cells in B3:B25 if they have a formula in it! ahh which i don't need.. only if the formula result is there.

That is why I mentioned your sample workbook should be representative of the real workbook!

Try this:
=COUNTIFS(B3:B25,"?*",H3:H25,"")

BSB

Didn't realize i was going to use formula's till i decided to add them, but that worked.. thanks

No probs at all mate.

BSB

I need to do the same thing only I need to count the blanks in column J where columns H and I have text. Can you add an AND?

Originally Posted by kbalfour

. . . I need to count the blanks in column J where columns H and I have text. . . .

COUNTIFS works on an AND basis. Conditions in each range-condition pair must be satisfied to be included in the count.

=COUNTIFS(J3:J25,"",H3:H25,"?*",I3:I25,"?*")

Note: the 1st condition, "", includes both truly blank cells as well as cells evaluating to "". If that's what you want, fine. If you want only truly blank cells, you need to use

=COUNTIFS(J3:J25,"=",H3:H25,"?*",I3:I25,"?*")

OTOH, if you only want cells evaluating to "" but not truly blank cells, that requires the obscure

=COUNTIFS(J3:J25,"*",J3:J25,"",H3:H25,"?*",I3:I25,"?*")

where the first pair checks that cells are text, and the second that they're blank or evaluate to "", combined they mean only text = "".

Thank you...I'm going to try that and see what happens.