Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
If you apply datasubtotal then you should get a grand total at the end
(bottom) -- Regards, Peo Sjoblom "Neither rhyme nor reason" wrote in message ... 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 |
#3
|
|||
|
|||
how did you create your subtotals?
"Neither rhyme nor reason" wrote in message ... 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
Sorting a document with subtotals | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Copy/paste Subtotals | Excel Worksheet Functions | |||
Sorting a list with subtotals | Excel Worksheet Functions |