ExcelBanter - Thinking that indirect should work

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Thinking that indirect should work (https://www.excelbanter.com/excel-discussion-misc-queries/115798-thinking-indirect-should-work.html)

Brad

Thinking that indirect should work

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

All times are GMT +1. The time now is 10:03 AM.