Find a result from "WEEKNUMBER" and text

[y_not]

Thanks for reading.

Sheet1 has a named cell called WEEKNUMBER into which the week number is entered
Column A contains all the locations
Column B needs to contain the margins based on the WEEKNUMBER figure

Data is in a "SITES" tab within the same workbook.
The week numbers and margins for all the locations (around 3500 rows) are


The attached gives a simple example of the workbook.

Many thanks

[Pete_UK]

Put this in B4:

=SUMIFS(SITES!D:D,SITES!A:A,$C$1,SITES!B:B,A4)

then copy down.

Hope this helps.

Pete

[AndyLitch]

TEST.xlsm

That uses a macro

[y_not]

Sir - you are a genius! Works brilliantly and I can even understand it!
Many thanks

[Pete_UK]

Glad to hear that. Thanks for feeding back, and for the rep.

Pete