Adding the same cell from different Sheets but not all sheets

[Jane2395]

I have a workbook of around 100 Sheets all of them named with a number, I want to add the cell F10 from 15 sheets together. How do i do this ?

Thanks!

[alansidman]

Use this syntax =Sheet2!A1+Sheet3!A1+......

[Jane2395]

Is this the only way of doing it ? Just seems quite a long way round. Thank you!

[JohnTopley]

=SUM(First:last!A1)

Where First and Last sheets Prefix/Suffix sheets to SUMMED

Or simple

=SUM(Sheet1:Sheet15!A1)

[alansidman]

John's solution will work only if the sheets are in consecutive order. If your sheets are configured that way, it is the shorter, more efficient method.

[Jane2395]

The sheet are not consecutive! Thank you for you help

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.