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

Exclude $ Amount from sum based on how many months its been 1
Automation of scanned file storage based on content 0
Calculating total amount in a Pivot Table 1
copy multiple records based on criteria or total amount 22
Auto-populate spreadsheet based on database info? 1
SumIf 4
Sumif data from multiple columns 4
SumIf formula from one column based on criteria from two other col 13

Top