Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sums from a cell on multiple worksheets
I have a workbook that is going to have a new worksheet put in everyday. it
is a copy from a master that will be named for that days date. I need to get the sum of all M10s from all of the worksheets to the "Total" worksheet. Today there are only 10 worksheets but by the end of the year there will be 30. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sums from a cell on multiple worksheets
--Insert a dummy sheet as the last sheet and name it 'last'
--In the total sheet apply this formula. If the first sheet is named as 1 =SUM('1:Last'!M10) If this post helps click Yes --------------- Jacob Skaria "jtfalk" wrote: I have a workbook that is going to have a new worksheet put in everyday. it is a copy from a master that will be named for that days date. I need to get the sum of all M10s from all of the worksheets to the "Total" worksheet. Today there are only 10 worksheets but by the end of the year there will be 30. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display sums from multiple worksheets on one worksheet | Excel Discussion (Misc queries) | |||
Adding sums from different worksheets | Excel Worksheet Functions | |||
what formula do I use to add sums from other worksheets to a sum s | New Users to Excel | |||
Sums from different worksheets | Excel Worksheet Functions | |||
How come some worksheets automaticly change sums and others don't. | Excel Discussion (Misc queries) |