Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Adding cells on worksheets
0 views
Skip to first unread message
Ian Fareham
Nov 6, 2003, 11:35:10 AM11/6/03
to
Hi, I want to add the same cell from each worksheet within
a range of say 10 worksheets in the same document. I know
I can go to each sheet and select the cell and add it
maunally to the next sheet cell etc but there has to be a
shortcut as one of my documents has over 100 sheets! Say I
ant to add A1 sheet 1 to A1 sheet 2 etc HELP!
a range of say 10 worksheets in the same document. I know
I can go to each sheet and select the cell and add it
maunally to the next sheet cell etc but there has to be a
shortcut as one of my documents has over 100 sheets! Say I
ant to add A1 sheet 1 to A1 sheet 2 etc HELP!
Randall Roberts
Nov 6, 2003, 12:07:03 PM11/6/03
to
use this formula
=SUM(Sheet1:Sheet2!A1)
sheet1 is the name of your fist sheet
sheet two is the name of your last sheet
Randall Roberts
gord_dibben
Nov 6, 2003, 3:12:20 PM11/6/03
to
Ian
=SUM('Sheet1:Sheet100'!A1)
If your sheets are not numbered consecutively or have unique names, the
easiest method is to insert a new worksheet at start and one at end.
Then =SUM('start:end'!A1) to SUM all A1's on all sheets.
Gord Dibben XL2002
On Thu, 6 Nov 2003 08:35:10 -0800, "Ian Fareham" <ifar...@whitecliff-bay.com>
wrote:
>Hi, I want to add the same cell from each worksheet within
0 new messages