Geek asks and answers

Excel: return the number of cells that are not filled

I am trying to find a function that will return the number of cells within a given range in which there is a number. I want to calculate the number of answers that people gave, regardless of the value that they entered in the cell.
How should I do it?

+5
source share
3 answers

If you are looking for multiple cells containing numerical values, then a function COUNT()is what you are looking for:

=COUNT(A1:D6)

If you are looking for the number of cells with non-empty values ​​(numeric or others), then this COUNTA()is the correct function:

=COUNTA(A1:D6)

, (.. ="" - ). , :

=SUMPRODUCT((E7:G10<>"") * 1)
+14

LEN, , , .

=LEN(A1)>0
+1

You should use count to count the number of numbers:

=COUNT(Your_range)

Count will not count the number of cells that do not have a number (but they do not count them?)

0
source

More articles:


All Articles