How to do I Sum across worksheets in a Workbook ?

[ashwin28]

I get a daily sales workbook from my various stores showing various data. Each workbook contains several worksheets from Day 1 to Day 30. How do I sum up the various data across the worksheets without having to do manually =SUM(Worksheet1 Reference + Worksheet2 Reference + ....). All the fields are common across the various worksheets, only values differ due to various sales amounts.

thanks,

ashwin

 

[Brian from Maui]

Merry Christmas,

Insert two new worksheets named First and Last. Insert all relevant sheets between the two. In your summary sheet enter,

=SUM(FIRST:LAST!A1)

on the assumption that A1 in ALL sheets houses the value you want summed.