Get the sum value for every worksheet
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? |
Get the sum value for every worksheet
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 "Kelvin Lee" wrote in message ... | 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? |
All times are GMT +1. The time now is 07:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com