Sumproduct formula syntax

[erniepoe]

Hi all, have the following Sumproduct formula, column D and G are dates, as well as AL40. In the case, neither the month or year of column G equals the month/year of AL40, so it should be returning a 0, but it is returning a value, so I am guessing I have a syntax error in the formula somewhere, does anybody have an idea of what that might be?

Thanks so much for any help.

Best,
Ernie


=SUMPRODUCT(($D$41:$D$95<=AL$40)*MONTH($G$41:$G$95=MONTH(AL$40))*YEAR($G$41:$G$95=YEAR(AL$40))*($I$41:$I$95="GBP"))

 

[Fluff]

You look to be missing some brackets, try

=SUMPRODUCT(($D$41:$D$95<=AL$40)*(MONTH($G$41:$G$95)=MONTH(AL$40))*(YEAR($G$41:$G$95)=YEAR(AL$40))*($I$41:$I$95="GBP"))

 

[erniepoe]

Success, thank you so much Fluff! You did in 30 seconds what was taking me 4 hours and counting. Cheers!

 

[Fluff]

You're welcome & thanks for the feedback.