View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson Ken Johnson is offline
external usenet poster
 
Posts: 1,073
Default 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