| 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 |
|
#2
|
|||
|
|||
|
=COUNTA(A1:A14)
Vaya con Dios, Chuck, CABGx3 "Darby" wrote: 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 |
|
#3
|
|||
|
|||
|
You're close:
=COUNTIF(A1:A14,"<"&"") -- Regards, Dave "Darby" wrote: 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 |
|
#4
|
|||
|
|||
|
Thanks, works like a charm
"David Billigmeier" wrote: You're close: =COUNTIF(A1:A14,"<"&"") -- Regards, Dave "Darby" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
