1. ## Counting ""

Hi Lounger, I need some help with this.

I have this simple formula in a column S that extends down a 100 or so rows. =IF(U\$6="","",IF(\$S7="no","N/A",""))

I'm trying to count the number of "" (appearing empty) in column U. Although the range extends down 100 or so rows there are only values in column "S" in the first 20 cells (at this stage) of which only 2 cells contain "".

I'm trying to create a formula that would return a total of 2.

I hope that makes sense

Any thoughts/suggestions would be much appreciated.

2. Have you tried the COUNTBLANK function?

cheers, Paul

3. Hi Paul - yes tried that but no luck

=IF(U\$6="","",IF(\$S7="no","N/A",""))
..are you sure this is the formula you have?????

zeddy

Your formulas in Column S are ambiguous in that they will always return "" because they depend on values in the S column below it to be equal to "no". This will not occur unless you physically overwrite the formula in column S with "no" or type "no" in the last row. Could this be what you are looking for? In cell S6 place this formula and copy down:

=IF(U6<>"","",COUNTIF(\$U\$6:\$U6,""))

Count.png

HTH,
Maud

6. Could the ISBLANK function be used?

7. If COUNTBLANK doesn't work I can't see ISBLANK working.

cheers, Paul

8. CountBlank would certainly work. But Verada is attempting to find a formula in Col S that he copies down to do so. I am guessing that he wants to progressively count them. In cell S6 and copy down, this would work equally as well.

=IF(U6<>"","",COUNTBLANK(\$U\$6:\$U6))

9. Hi All - thanks for your help and thoughts.

My idea was that if the cell was "" based on the "if" criteria that would prompt a value to be entered (by a data entry person) that would over-right the formula. I might have a re-think about the best was to do this.