Thinking that indirect should work

[Guest]

What I want to do in the formula below is to have the $F$4 be variable going
from F4 to F369 (and yes $B$4 will have to changes as well)

=SUMPRODUCT($F$4:$F$370,--(MONTH($B$4:$B$370)=$O14))

Tried a couple of times and couldn't make it work- what do you recommend?
Thanks in advance

 

[Guest]

I don't know what I was doing wrong before but

=SUMPRODUCT((INDIRECT("F"&R5)):$F$370,--(MOD((INDIRECT("B"&R5)):$B$370,7)=$O6))/SUMPRODUCT(--($F$4:$F$370>0),--(MOD($B$4:$B$370,7)=$O6))

Works