list sums from multiple worksheets

D

dfthompson

how do i list individual sums from multiple worksheets to seperate cell
in a master worksheet? all individual worksheets are identical i
structure
 
C

Corundum

Unless I'm misunderstanding your purpose I believe you simply need t
include the specific spreadsheet name in the formula for the cell.

For example to display the sum of C1:C50 of Sheet 1 in cell B2 of Shee
2, use in that cell the formuls:

=sum(Sheet1!C1:C50)

This also works for data contained within other workbooks
 
D

dfthompson

example

sheet2 cell a20 =SUM(A1:A19)
sheet3 cell a20 =SUM(A1:A19)
sheet4 cell a20 =SUM(A1:A19)

okay

how do i get
sheet1 cell a1 =Sheet2!A20
sheet1 cell a2 =Sheet3!A20
sheet1 cell a3 =Sheet4!A20
without having to manually change worksheet name
 
R

RagDyer

Enter this in A1, and drag down to copy:

=INDIRECT("Sheet"&ROW()+1&"!A20")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


example

sheet2 cell a20 =SUM(A1:A19)
sheet3 cell a20 =SUM(A1:A19)
sheet4 cell a20 =SUM(A1:A19)

okay

how do i get
sheet1 cell a1 =Sheet2!A20
sheet1 cell a2 =Sheet3!A20
sheet1 cell a3 =Sheet4!A20
without having to manually change worksheet name?
 
Top