 # Help with Counting blanks if 1 of 2 conditions are met

• So, Ill try to explain what Im doing. I want to count blanks in a column if one of multiple conditions are met.

In another section of my sheet, I don't have multiple conditions, so the formula im using is: =IF(NOT(ISBLANK(C3)),(COUNTBLANK(C4:C19)),0) and its working well because I'm simply choosing if C3 is blank or not.

However, in another cell, my problem cell, I want to countblank from either G4:G15 OR G4:G20 depending on whether the value in G3 is exactly 12 OR exactly 17
I've tried IF(OR... with no luck, and a bunch of random formulas that I thought would work. Ive tried to nest (not sure if thats right) IF formulas using:
=IF(G3="12",(COUNTBLANK(G4:G15)),(IF(G3="17",(COUNTBLANK(G4:G20)),("0"),("0))

And i thought that closest that I had was =(IF(G3="12",(COUNTBLANK(G4:G15)),("0"))*IF(G3="17",(COUNTBLANK(G4:G20)),("0")))

Either I get an error message, or the value in my selected cell shows as "0" even when I enter 12 or 17 into G3.

If this makes sense...any suggestions??

Thanks Everyone.

• Not sure why you have placed the quotes around the numbers unless these are actually text values. If they are numbers then something like the following should work:
=IF(G3=12,COUNTBLANK(G4:G15),IF(G3=17,COUNTBLANK(G4:G20),0))

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!