Question Locked

Automated =SUM() Sequence?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have a spreadsheet with 4 sheets (while testing) that will have around 300 sheets eventually. I am adding up the value of the SAME CELL but within several other sheets (eventually all of those 300 I mentioned earlier).
I'm using =SUM for this...so far looks like this:
=SUM('001'!C15,'002'!C15,'003'!C15,'004'!C15)
as you can see the current names I've given the sheets are 001,002,003,004 - what I want to avoid is to have to manually enter " '###'!C15, " every time I create a sheet.
Any ideas? I don't think the solution must be within Excel, I just need something that creates this sequence for me, maybe another text editor..?

Actually, as I was writing this somebody just told me that what I really need is to add something to the formula so that it automatically reads from the same cell on ANY new sheet created....STILL no answer to what I need.

2 replies

by tobif

What about
=sum(FirstSheet:LastSheet!A1)
Isn't that better?

(edited for clarity)
2nd edit - missed a bit on format. Now it's checked.

This discussion is closed to new replies.