How do I sum up totals from different worksheets?
B Bob Phillips Aug 23, 2006 #2 =SUM(Sheet1!A1:A10)+SUM(Sheet2!B5:B25) or maybe =SUM(Sheet1:Sheet3!A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=SUM(Sheet1!A1:A10)+SUM(Sheet2!B5:B25) or maybe =SUM(Sheet1:Sheet3!A1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
