sum product formula

[steddas]

Hi All

i currently have a formula which returns a quantity sold based on days of the week monday through to sunday for 1 year

=SUMPRODUCT((WEEKDAY('AVGAS OVERGROUND'!$B$4:$B$368,2)=1)*'AVGAS OVERGROUND'!$F$4:$F$368)

as we are in a new year and the columns b and f can go on for multible years is there a way of adding year into the formula

thank you in advance

steddas

[TMS]

Maybe:

Please Login or Register  to view this content.

[steddas]

thank you so much that worked perfectly

Kind Regards
Steddas

[TMS]

You're welcome. Thanks for the rep.