When is a cell empty and how do I empty it.
On Aug 11, 7:33 am, "C Brandt" wrote:
I ran across an interesting problem. I need to count the number of valid
entries and I simply used an IF statement to apply criteria to a column of
cells and copied only those I was interested in counting to the adjacent
column, then used COUNTA( ) to count them.
B12 is equal to =IF(and(A12 <MAX,A12MIN,A12,"")
Didn't work. It counts the "" cells.
If I manually delete one of the "" entries in column B, it doesn't count it.
Is there a simple solution?
Thanks,
Craig
Hi Craig,
One way would be to stop using "" and use something like "NO" instead,
then use COUNTIF(B:B,"NO").
Ken Johnson
|