Counting bank Cells based on changing criteria

[ENAPo]

hi! I am using Excel 2010.

BTES worksheet:
acct# Oct-13 Nov-13 Dec-13
13245 850
12458 850
45864
12385 1500


MainList - F2= (current month)

Based on the current month (which I planned on typing in) on the MainList worksheet I need to count how many blank cells are in the table above. The information above is on a separate worksheet but I can change that in the formula. Every month gets a new column.

This is what I have but its not working correctly: =SUMPRODUCT(--(BTES!AD1:BQ18=F2),--(BTES!AD1:BQ18<>" "))

Thank you!!!

 

[NBVC]

usually when checking for blank cells, you indicate with the two double quotes next to each other, without a space between.

e.g. =SUMPRODUCT(--(BTES!AD1:BQ18=F2),--(BTES!AD1:BQ18<>""))

but not sure I understand...

You want to check the column that has a header with the date you enter in F2 and count the blanks in that column?

Maybe then?

=COUNTIF(INDEX(BTES!AD2:BQ18,0,MATCH(F2,BTES!AD1:BQ1,0)),"")

 

[ENAPo]

That worked perfectly. Thank you!!!