Calculate a Grand Total

K

Kim Jackson

I have an Excel file with 30 years worth of detail figures with "sums
at the end of each year. How do I add up all the "sum" totals to get
Grand Total for the entire 30 years without changing all the "sums" t
"subtotals"
 
F

Frank Kabel

Hi
try a formula like
=SUM('sheet1:sheet30'!A10)
if A10 is the summary cell on each of your sheets
 
A

AlfD

Hi!

Is it helpful to mention that the sum of all of the items plus the su
of the sums of all of the items will be twice the Grand Total of th
items??


Al
 
D

David McRitchie

Hi Kim,
Different interpretation. But it sounds like all your detail values
and SUMs are in one column (in one sheet). There is no way to add up
only detail constants or only the SUM formulas directly in Excel. SUBTOTAL
is builtin and will not be added in as you know because you mentioned
it. So without conversion You would simply total the entire column
and divide by two.


Frank Kabel said:
Hi
try a formula like
=SUM('sheet1:sheet30'!A10)
if A10 is the summary cell on each of your sheets
Click to expand...
 
L

Lady Layla

She could manually enter =sum(and hold control key down select the total
ells) --- cumbersome but will work



: Hi Kim,
: Different interpretation. But it sounds like all your detail values
: and SUMs are in one column (in one sheet). There is no way to add up
: only detail constants or only the SUM formulas directly in Excel. SUBTOTAL
: is builtin and will not be added in as you know because you mentioned
: it. So without conversion You would simply total the entire column
: and divide by two.
:
:
: > Hi
: > try a formula like
: > =SUM('sheet1:sheet30'!A10)
: > if A10 is the summary cell on each of your sheets
: >
: > --
: > Regards
: > Frank Kabel
: > Frankfurt, Germany
: >
: > Newsbeitrag : > > I have an Excel file with 30 years worth of detail figures with
: > "sums"
: > > at the end of each year. How do I add up all the "sum" totals to get
: > a
: > > Grand Total for the entire 30 years without changing all the "sums"
: > to
: > > "subtotals".
: > >
: > >
: > > ---
: > > Message posted
: > >
: >
:
:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The next Grand Theft Auto title has been officially announced 0
Help, add subtotals included in one column to get a grand total 1
Grand Total for Rows not Working in a Pivot Table 1
Removeing the Grand Total Line when subtotals are removed 11
how to calculate hours worked daily & minus 30 min lunch, 7am-5pm 1
Totaling Subtotals 2
Pivot Table Grand Total 3
Pivot Table Grand Total Plus Calc Field or GT Running Balance 6

Top