| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Non Blank in column
I would like to count from A12:A1000 how many cells are NOT blank. What
function can I use for this? Thank you. |
|
#2
|
|||
|
|||
|
One way:
=COUNTA(A12:A1000) In article , Diane Alsing wrote: I would like to count from A12:A1000 how many cells are NOT blank. What function can I use for this? |
|
#3
|
|||
|
|||
|
Yup - thanks!
"JE McGimpsey" wrote: One way: =COUNTA(A12:A1000) In article , Diane Alsing wrote: I would like to count from A12:A1000 how many cells are NOT blank. What function can I use for this? |
|
#4
|
|||
|
|||
|
thanks for the formula.
"Diane Alsing" wrote: Yup - thanks! "JE McGimpsey" wrote: One way: =COUNTA(A12:A1000) In article , Diane Alsing wrote: I would like to count from A12:A1000 how many cells are NOT blank. What function can I use for this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
| Count number of unique items in a column that contains duplicates | Excel Worksheet Functions | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
| Repeating Column Headers And Blank Worksheets With Fomulas | Excel Discussion (Misc queries) | |||
Linear Mode
