Extracting data from 2 x tables using set criteria

Whilst there is an indication that the data to sum in column C starts at week number 6 (C28) and goes onto week 17 (C29) there is nothing to indicate that column F starts at week 11 therefore if you put data in F6:F10 this will not work but this gives you the answer you need.

=SUMPRODUCT((B5:B25>=C28)*(B5:B25<=C29)*(C5:C25))+SUMPRODUCT((B5:B25>=C28)*(B5:B25<=C29)*(F5:F25))

You should be able to adjust the row numbers for example 2 yourself.

For Example 1

Formula:

Please Login or Register  to view this content.

for Example 2

Formula:

Please Login or Register  to view this content.

alternatively with SUMIFS
For Example 1

Formula:

Please Login or Register  to view this content.

For Example 2

Formula:

Please Login or Register  to view this content.