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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating total amount in a Pivot Table 1
copy multiple records based on criteria or total amount 22
Sumif data from multiple columns 3
SumIf formula from one column based on criteria from two other col 10
SumIf 4
SUMIF or SUMPRODUCT or ?? 2
filtering question.... 1
Selecting date specific data from different spreadsheets 1

Top