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