Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/COUNTA
(view source)
Revision as of 20:50, 2 November 2013
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>
----
----
Swapna
writer
2,661
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Community portal
Current events
Recent changes
Help
Tools
ZCubes Web Platform
Printable version