MrExcel Publishing
Your One Stop for Excel Tips & Solutions

A totalled Spreadsheet from an existing spreadsheet.

Posted by Eric Metoyer on February 08, 2002 11:01 AM

I am not that computer literate so forgive me. However, I am trying to create a spread shet that totals in the same cell the sum of all spread sheets in the entire documents. You send me a formula.

Posted by XLmon on February 08, 2002 11:15 AM

to sum all the values in cell B2 of sheets 2 thru 10, in sheet1 cell B2 put: =SUM(Sheet2:Sheet10!B2)
You send me a thank you.