writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 99:
Line 99: − + − + − +
no edit summary
<div id="5SpaceContent" class="zcontent" align="left">
<div id="5SpaceContent" class="zcontent" align="left">
=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>
</div>
----
----