Sum a certain cell on every sheet, including newly added sheets?.

  • Thread starter Thread starter Ken Hepting
  • Start date Start date
K

Ken Hepting

I am creating an Excel file that will be used for a bill
of materials for the job I am working on. On every sheet
there are two cells... the quantity that is ordered that
day, and the quantity that has been ordered overall. I
need a formula that will calculate the overall quantity.

The problem I am having comes up when a new sheet is added
for the new quantity ordered. How do I get that to be
included in the summation?

I understand that it is simple to add all the A12 cells
and put that summation in a certain cell. But, when a new
sheet is added, that needs to be included. Below is the
simple part...

=SUM('Panel (1)'!A12+'Panel (2)'!A12)+'Panel (3)'!A12)

But, when sheet Panel (4) is added to the workbook, how do
I get is to be included in the overall summation?

Does this make sense?

Thanks,
Ken H
 
=sum(firstsheet:lastsheet!a1)
create a dummy last sheet and insert new sheet before last
 
Back
Top