Sum of columns in multiple sheets?

[jppnm]

I have 50 sheets in a spreadsheet. I need column C in all 50 sheets added up. I don't want to limit (*c:1-C999 because there will be more entries later) but just sum up the entire column as I add entries. How can I do this? Thanks for any help!

I'm keeping track of my receipts, and want the grand total of spending in a new sheet.

[XOR LX]

Hi,

Do your 50 sheets follow an incremental naming convention, e.g. Sheet1, Sheet2,..., Sheet50?

Regards

[jppnm]

No, the sheet names are the places I shop (*Staples, 7-11, OfficeMax, etc.)

[martindwilson]

just use
=SUM('Sheet 1:Sheet 50'!C:C)
if you are gong to insert new sheets createa a spare one and move it to the end name it say LAST
then
=SUM('Sheet 1:LAST'!C:C)

[oeldere]

What's the specific reason you use 50 sheets?

Probably it's better to make 1 sheet with all the data in it.

You can e.g. use pivot table (or sumproduct) to analyze your data.

[martindwilson]

or add another new sheet call it FIRST
make sure its the first tab
then
=SUM('FIRST:LAST'!C:C)