software

If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell quot;A1quot;. How do I add all these numbers up without clicking on
each cell to add to the Sum function?

If those sheets are contiguous, say sheets 1 through 6, use

=SUM(Sheet1:Sheet6!A2)quot;Derrardquot; wrote:

gt; If I have multiple spreadsheets with a subtotal on the same cell on each
gt; sheet, say cell quot;A1quot;. How do I add all these numbers up without clicking on
gt; each cell to add to the Sum function?

Derrard, something like this,

=SUM(Sheet1:Sheet3!A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003quot;Derrardquot; gt; wrote in message
...
gt; If I have multiple spreadsheets with a subtotal on the same cell on each
gt; sheet, say cell quot;A1quot;. How do I add all these numbers up without clicking
gt; on
gt; each cell to add to the Sum function?
Hi!

Make sure all the sheets needed are contiguous:

Tab order:

Summary | Sheet1 | Sheet2 | Sheet3 |Then:

=SUM(Sheet1:Sheet3!A1)

Or, this is a popular method:

Enter an empty sheet named Start before Sheet1 and another empty sheet named
End after Sheet3:

Summary | Start | Sheet1 | Sheet2 | Sheet3 | End |

Then:

=SUM(Start:End!A1)

Any sheets between Start and End will be included in the Sum.

Biff

quot;Derrardquot; gt; wrote in message
...
gt; If I have multiple spreadsheets with a subtotal on the same cell on each
gt; sheet, say cell quot;A1quot;. How do I add all these numbers up without clicking
gt; on
gt; each cell to add to the Sum function?