15 replies
by jgeist
by gened_1
by al hedstrom
by gened_1
by kracquet7
If all the cells you want to count have some type of data, the formula should be =COUNTA(range)
However, if you want to count blanks, the formula would be =countblank(range)
If this doesn't work, please let us know what is in the cells (numeric data, alpha data, blanks, or formulas).
by gened_1
by instructor
by gened_1
by kevin holden
Hello,
All of the answers are good, but we all have the same problem of the fact that we do not have all the specific details that we need. If need a count of the cells no matter what they contain (numbers, text, formulas, or are blank). You can use this formula, It will basically just count the number of cells and adjust itself automatically when rows are added or deleted.
=(COUNTA(C4:C23))+(COUNTBLANK(C4:C23))
Of course you must change the range references to meet you desired column.
by gened_1
by khinton
try this:
=COUNTA(D4:D9)+COUNTBLANK(D4:D9)
where d4:d9 is enter your own range
this will count all regardles of contents
if you want to see cells with entries use =counta(range) or =countblank(range)to count blank cells.
kevin
by gened_1
by pdsmith
If you are looking for a count of cells on a conditional basis, for example if you want to count cells that only have a YES or a 1 in them. You can use a COUNTIF formula.
=COUNTIF(A1:A10, "YES")or
=COUNTIF(A1:A10, 1)
This will give you the count of the cells A1 through A10 that are equal to "YES" or 1.
by gened_1
by gened_1
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending