writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 101:
Line 101: − + − + − <font size="3"><font face="Times New Roman">Counts the number of cells that contain numbers in the last 4 rows of the list (3)</font></font>+ + + + + + + + + + + +
no edit summary
=COUNT(A1:A5)
=COUNT(A1:A5)
| valign="top" |
| valign="top" |
Counts the number of cells that contain numbers in the cells A1 to A5. ''Gives result 3
Counts the number of cells that contain numbers in the cells A1 to A5, ''returns 3'' as a result.
|-
|-
| valign="top" |
| valign="top" |
COUNT(C5:C7)
=COUNT(A4:A7)
| valign="top" |
| valign="top" |
Counts the number of cells that contain numbers in the cells A4 to A7, ''returns 3'' as a result.
|-
| valign="top" |
=COUNT(C5:C7)
| valign="top" |
Counts the number of cells that contain numbers in the cells C5 to C7, ''returns 0'' as a result. COUNT() ignores the empty cells.
|-
| valign="top" |
=COUNT((D1:D4),2)
| valign="top" |
Counts the number of cells that contain numbers in the cells D1 to D4, ''returns 2'' as a result.
|}
|}
</div>
</div>
----
----