How to do I Sum across worksheets in a Workbook ?

ashwin28

New Member
Joined
Dec 18, 2005
Messages
11
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
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,909
Messages
5,574,985
Members
412,630
Latest member
Eireangel
Top