Tuesday, March 31, 2009

Subtotal



SUBTOTAL(function number,ref1,ref2,...)
The subtotal function is designed for column of data (veritical ranges). If you use this function in horizontal ranges you will not get the desired output.
Here I would like to explain the subtotal using the sum (function number 9 / 109)
function number 9 - sum the ranges including the hidden rows
function number 109 - sum ranges does not include hidden rows
See the screen shot below for detail and understanding this function
Get Free Updates:
We will send a confirmation mail. Please check your inbox/spam folder to confirm it
Related Posts Plugin for WordPress, Blogger...
 

Copyright © 2011 All Rights Reserved | Designed by Amith | Post RSS | Home | About | Disclaimer | Privacy Policy | Contact