These pages are no longer updated and are only available for archive purposes.
Click here to visit the pages with updated information.
If the range A1:A1000 contains values and several subtotals, you probably will
have some difficulties to add the grand total of the values in this range. One easy way to
find the grand total is by using this formula :
This solution assumes that all the subtotals adds all the items in the range.
Another way to find the grand total is by using the SUBTOTAL(functionnumber,cellref)-function
when you add the subtotals in the range. To find the grand total you can type in this
The SUBTOTAL()-function will ignore the result from all other SUBTOTAL()-functions.
Note! The SUBTOTAL()-function will only calculate visible cells.
Function numbers and SUBTOTAL functions :
||average of the values in the range
||count of cells containing values in the range
||count of non-blank cells in the range
||the maximum value in the range
||the minimum value in the range
||multiplies the values in the range
||standard deviation for samples of the values in the range
||standard deviation for populations of the values in the range
||the sum of the values in the range
||variance for samples of the values in the range
||varians for populations of the values in the range
Document last updated 1999-08-14 12:44:13