Manuals/calci/SUBTOTAL

From ZCubes Wiki
Revision as of 20:45, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="4SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Syntax

Remarks

Examples

'''''''  ''''

Description

SUBTOTAL

 

SUBTOTAL(N1, N2, ...)



 It is generally used in columns of data. The columns can have resultant values of other functions.



 This function calculates subtotal in the list.



 

Lets see an example,

B

60

12

120

25

=SUBTOTAL(4,B2:B5) is 120

Column1 Column2 Column3 Column4
Row1 60 120
Row2 12
Row3 120
Row4 25
Row5
Row6
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SUBTOTAL&oldid=609"