Sum up Worksheets

[Veronica_sky]

If i got 10 worksheets in an excel book, is there any formula i can use to sum up the total quantities for a particular item in that 10 worksheet Instead of click "+" the worksheets one by one?

 

[Haldoug]

If the ten worksheets are the same format, you could look into the consolidate function.

 

[jeffreybrown]

A common method is too name one sheet First and one Last and then put all the sheets inbetween and then use...

=SUM(First:Last!A1)