Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Manuals/calci/SUMIF
(view source)
Revision as of 17:38, 15 November 2013
1 byte added
,
17:38, 15 November 2013
no edit summary
Line 8:
Line 8:
'''R''' are the actual cells to add
'''R''' are the actual cells to add
−
C1 C2
C1 C2
Line 19:
Line 18:
R4 12000 500
R4 12000 500
+
<nowiki>=SUMIF(C1R1:C1R4,">5000",C2R1:C2R4) is 1050</nowiki>
<nowiki>=SUMIF(C1R1:C1R4,">5000",C2R1:C2R4) is 1050</nowiki>
</font></font></div></div>
</font></font></div></div>
+
----
----
<div id="1SpaceContent" class="zcontent" align="left"><div>
<div id="1SpaceContent" class="zcontent" align="left"><div>
Jayaram
Administrators
, writer
3,314
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