Im trying to create a formula I guess it would be a sumif but not too sure..
OBJECTIVE: To sum the weekly totals from multiple worksheets weekly totals.

Each worksheet has a table that is named after a person. (e.g.: 1st DAVID_INCOME, 2nd LISA_INCOME, 3rd JANE_INCOME).
Within the tables the relevant columns and their named ranges are:
Col A: has each date of work; Named data range: DATE
Col B: has income earnt, corresponding to the date; Named data range: AMOUNT
Col E: Is the week number for the corresponding date; Named data range: WEEK NUM, it has this formula: =WEEKNUM(DAVID_INCOME[[#This Row],[DATE]])
Col F: Is the weekly total; Named data range: WEEKLY TOTAL It has this formula: =IF(DAVID_INCOME[[#This Row],[WEEK NUM]]<>E3,SUMIF(E:E,DAVID_INCOME[[#This Row],[WEEK NUM]],B:B),"")
Note: Table headers are in row 1; data starts in row 2

The last sheet has the summary table. That is where I want to create a formula to sum all the weekly totals.
Was not sure how to do it, so this is the EFY_SUMMARY I have created so far:
Col A: Have dates in each row in the column, starts at the start of the financial year, ending at the end of FY. They are in 7 day series; Named data range and Col header is START OF WEEK
Col B: is the week number for Col As corresponding date; Named data range WEEK_NUMBER 
Col C: this is where I want new formula to sum each persons weekly total.
First row is all the columns headings, so, Cell C2 I would want it to be Weekly total for week number 27 and it would sum week 27 Amount from David_Income worksheet and week 27 Amount from Lisa_Income worksheet and week 27 Amount from Lisa_Income worksheet.
The next row , Cell C3 would be the same as above but sum week 28 from each worksheet etc..
I hope this is not too confusing. Any help with creating this formula would be appreciated.

• Edited by jojogusto 6 hours 58 minutes ago