grand-total of subtotals ?

Hi,

I am looking for the formula that would allow me to grand-total the value of
subtotals in a column. I'm obviously new at this.

regards

g


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04

If you apply data>subtotal then you should get a grand total at the end
(bottom)

--

Regards,

Peo Sjoblom

"Neither rhyme nor reason" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I am looking for the formula that would allow me to grand-total the value
of
> subtotals in a column. I'm obviously new at this.
>
> regards
>
> g
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
>
>

how did you create your subtotals?

"Neither rhyme nor reason" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I am looking for the formula that would allow me to grand-total the value
> of
> subtotals in a column. I'm obviously new at this.
>
> regards
>
> g
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
>
>

Assuming your subtotals were created using the SUBTOTAL() function then you
can simply use the same function on the whole range and it will ignore them
and not doublecount anything. You have to be careful though in that if you
filter any rows then any hidden values in that range will not be summed.

As already suggested, take a look at Data / Subtotals, and also take a look
at Pivot tables. If your data can be used to feed a Pivot Table and you can
get your head round those you will never look back.

http://peltiertech.com/Excel/Pivots/pivotstart.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Neither rhyme nor reason" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I am looking for the formula that would allow me to grand-total the value
of
> subtotals in a column. I'm obviously new at this.
>
> regards
>
> g
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.805 / Virus Database: 547 - Release Date: 03-Dec-04
>
>