exclude amount from sumif total based on how many months

V

Vercingetorix.XIII

I need to exclude $$$ amounts from a sumif total based on how many months it
has been in service. Current formulas is: =SUMIF(M4:M23,"JJ",J4:J23) I need
it to scan a different column for how many months and anything over 9 it will
not add to the total. Thanks. V.XIII
 
P

Peo Sjoblom

=SUMPRODUCT(--(M4:M23="JJ"),--(N4:N23<=9),J4:J23)


where N4:N23 is the extra range you want to test for 9

--


Regards,


Peo Sjoblom
 
Top