Changes

Manuals/calci/COUNT (view source)

191 bytes removed , 21:32, 1 November 2013

no edit summary

Line 99: Line 99:

{| class="MsoNormalTable"

| valign="top" |

−

~~<nowiki>~~=COUNT(B2:B8)~~</nowiki>~~

+

=COUNT(A1:A5)

| valign="top" |

−

~~~~Counts the number of cells that contain numbers in the ~~list above (~~3~~)~~

+

Counts the number of cells that contain numbers in the cells A1 to A5. ''Gives result 3

|-

| valign="top" |

−

~~<nowiki>=~~COUNT(B5:B8)~~</nowiki>~~

+

COUNT(C5:C7)

| valign="top" |

Counts the number of cells that contain numbers in the last 4 rows of the list (3)

writer

2,661

edits