| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Countif not blank
I would like to count a the number of cells in a range that are not blank.
=countif(a1:a14,"<""") includes blank cells in its results. I checked to see if the cells were actually blank by using =countif(a1:a14,""),which counted the blank cells correctly. Anybody got any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
| Countif - Countif | Excel Worksheet Functions | |||
Threaded Mode
