Countif Problem

[Razoo]

I have a range of cells that I wish to check for 'data' or 'no data'
entered.

All I really need to know is whether a user has entered anything into any
one of the cells.

I am trying this formula:

=COUNTIF(A1:C100,"")

which works fine, returning the number of blank cells and decreasing that
number by 1 each time data is entered into a previously blank cell.

However, I need to invert the result. I want the formula to return 0 (zero)
when all of the cells are blank, and to increment the number by 1 each time
data is entered into a previously blank cell.

I hoped this formula would work, but it doesn't:

=COUNTIF(A1:C100,<>"")

This formula doesn't seem to work either:

=COUNTIF(A1:C100,NOT(""))

Any ideas?

Thanks,

 

[Bob Phillips]

Try

=COUNTIF)A1:C100,"<>")

HTH

Bob

 

[Razoo]

Try

=COUNTIF(A1:C100,"<>")

Thanks Bob, it works fine.