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
=SUMPRODUCT(--(MONTH($I4:$I3282)=1),--($L2:$L3271>0),$M4:$M3282)
Thanks,
Danny