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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,102,455
Messages
5,486,998
Members
407,575
Latest member
calc

This Week's Hot Topics

Top