ZCubes Wiki

Changes

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,"&gt;5000",C2R1:C2R4) is 1050</nowiki>
 
<nowiki>=SUMIF(C1R1:C1R4,"&gt;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

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/194890"