Here's a way to use dynamic named ranges.
1/. Create a dynamic named range for each Month
e.g.
Name:= Jan
Refers to:=
2/. In Sheet "Dynamic Frequencies" B2
Drag/Fill Down to Row 50.
3/. Unfortunately INDIRECT() doesn't like refering to dynamic named ranges so we can't drag this across by using INDIRECT(B$1) in place of Jan in step 2, so each month column has to be separately entered.
To do this Drag B2 across to C2 then in C2 change Jan to Feb (2 places) then double click the Fill Handle (the small square bottom right of the highlighted cell C2), this will fill down to row 50 as defined by Column B.
Repeat this for all the months.
Hope this helps.
Thanks for the Rep+
Don't know if I will have time to crack the SUMPRODUCT solution tonight, my brain's fried, and the Pub beacons.... .... .... might just give me in"spirit"ation!!!
Bookmarks