Sumifs for a Number of diferent worksheets

Matt_Chelmsford

Board Regular
Joined
Jan 31, 2009
Messages
156
Hi,

I have a total worksheet

I have 4 worksheets, Week 1, Week 2, Week 3 and Week 4. All set in the same format

To get the totals I need from each sheet, I have been using Sumifs.

To add up the totals from the different sheets, is there a alternative to =sumifs(Week1.....)+sumifs(week2...)+,etc.

Regards

Matthew
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,102,335
Messages
5,486,239
Members
407,538
Latest member
kbendelac

This Week's Hot Topics

Top