Get the sum value for every worksheet

K

Kelvin Lee

Let say I got more than 20 worksheets in a workbook.
In B2 of Sheet1, I want a sum value of A1 in every worksheet.
Insteed of add up with '+' sheet by sheet. Any faster way for it?
 
S

ScottO

It's good practice to insert a sheet called Start before the first
'real' sheet and a sheet called End after the last 'real' sheet,
then use a formula like =SUM(Start:End!A1) to get your result.
This will add A1 values in ALL sheets between the Start and End
sheets - that way you can insert or delete sheets between Start & End
and the formula will still work.
Rgds,
ScottO

| Let say I got more than 20 worksheets in a workbook.
| In B2 of Sheet1, I want a sum value of A1 in every worksheet.
| Insteed of add up with '+' sheet by sheet. Any faster way for it?
 
Top