Changes

Jump to navigation Jump to search
29 bytes removed ,  20:50, 2 November 2013
no edit summary
Line 90: Line 90:  
<div id="5SpaceContent" class="zcontent" align="left">
 
<div id="5SpaceContent" class="zcontent" align="left">
   −
<font size="3"><font face="Times New Roman"><nowiki>=COUNTA (B2:B8) is 6</nowiki></font></font>
+
=COUNTA (A2:A7) : Counts the number of cells that contain numbers in the cells A2 to A7, ''returns 6'' as a result.
   −
<font size="3" face="Times New Roman"> </font>
+
=COUNTA (B4:B7, 2) : Counts the number of cells that contain numbers in the cells B4 to B7 and number '2', ''returns 1 '' as a result.
 
  −
<font size="3" face="Times New Roman"> </font>
  −
 
  −
<font size="3" face="Times New Roman"><nowiki>=COUNTA (B1:B7, 2) is 7</nowiki></font>
      
</div>
 
</div>
 
----
 
----
writer
2,661

edits

Navigation menu