| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When is a cell empty and how do I empty it.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| in excel..:can't empty clip are" but already empty | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
