SUMPRODUCT with Multiple Conditions

[Danny99]

I am trying to sum in column M, based on the month in column I and values greater than 0 in column L. I cannot get the following sumproduct formula to work. I am using the month condition succesfully in a single condition, but it will not work when combined as shown below.


=SUMPRODUCT(--(MONTH($I4:$I3282)=1),--($L2:$L3271>0),$M4:$M3282)


Thanks,

Danny

 

[daniels012]

I know that SUMPRODUCT must have all the same ranges
Michael

 

[eggyjla]

second argument has to be the same size as arguments 1 & 3.

Try:

=SUMPRODUCT(--(MONTH($I4:$I3282)=1),--($L4:$L3282>0),$M4:$M3282)

 

[Danny99]

You guys nailed it and thanks!!!! When I saw it in the forum and way from the spreadsheet it stood out.

Thanks !!