Changes

Manuals/calci/COUNTA (view source)

Revision as of 02:38, 4 November 2013

6 bytes added , 02:38, 4 November 2013

no edit summary

Line 99: Line 99:

−

=COUNTA(A1:A7) : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.

+

=COUNTA(A1:A7) : Counts the number of cells that contain numbers in the cells A1 to A7, ''returns 6'' as a result.

−

=COUNTA(A4:A7, 2) : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', ''returns 5'' as a result.

+

=COUNTA(A4:A7, 2) : Counts the number of cells that contain numbers in the cells A4 to A7 and number '2', ''returns 5'' as a result.

−

=COUNTA((B1:B5),"A",11) : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.

+

=COUNTA((B1:B5),"A",11) : Counts the number of cells that contain numbers in the cells B1 to B5 , text value "A" and number '11', ''returns 4'' as a result.

</div>

----

Swapna

writer

2,661

edits