COUNTIF with blank and notblank
Posted on 2011-02-27
I have a spreadsheet with a column that has text. Some cells are blank.
I have these two formula's to count:
A blank cell should be counted as zero, but is not for some reason. Actually, I can not have all the blank cells counted as I am looking at the whole column. Need to stop looking for blanks when column I has its first blank cell.
To the main question...why aren't blank cells being counted?
Does the "1" suffice to count a non-blank cell?
Thanks for any assistance