Sums from a cell on multiple worksheets

J

jtfalk

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
 
J

Jacob Skaria

--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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top