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,

Barb,

Is this what you mean

=SUMPRODUCT(--(YEAR(INDIRECT(B100&":"&B100))=YEAR(CurrentMonth)) )

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Barb Reinhardt" wrote in message
...
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,