Sumifs for a Number of diferent worksheets

[Matt_Chelmsford]

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

 

[Aryatect]

Hi,

You can try =SUMIF(Week1:Week4!A1:A10........