Perform a calculation on same cell across many worksheets

P

Pat Adams

I need to perform a calculation on my master sheet that will be the same and
reference the same cells across numerous worksheets, actually I will have a
series of these things.

Does anyone know how to get excel to continue performing a function until it
gets through all the worksheets and then stop (& not think it has encountered
an error)?
 
G

Gord Dibben

The easiest method is to insert two dummy sheets..........one to the right of
Master and one at the end.

Name them Start and End

In a cell on Master sheet =SUM(Start:End!A1:A10)

Insert any new sheets between Start and End


Gord Dibben MS Excel MVP
 

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

Similar Threads

Conditional SUM across multiple worksheets 0
SUM function across multiple worksheets within one workbook 4
Average formula across future worksheets 2
summing difference cell values across worksheets 4
countif in many worksheets 2
summing values for the same cell in 36 different worksheets 1
summary values across worksheets within the same workbook 2
Adding same cells across multiple worksheets 2

Top