I have a bit of a complicated SUMPRODUCT question.

1) I want the year of row 3 to match the year of the named range
"CurrentMonth"
2) The row # for the second array is defined in B100 (for example)

Can someone assist?


KEep in mind that there are numeric and text values in row 3 as well as in
the dynamic row #.

Thanks,