Exclude $ Amount from sum based on how many months its been

[Vercingetorix.XIII]

I need a formulas to exclude $$ Amounts from sumif based on how many months
its been in service, example current formulas is:=SUMIF(M4:M23,"JJ",J4:J23)
but I need it to check another column and if it has been over 9 months,
exclude that figure from the total. Any ideas???? I appreciate all the help I
have been getting here.

 

[smartin]

I need a formulas to exclude $$ Amounts from sumif based on how many months
its been in service, example current formulas is:=SUMIF(M4:M23,"JJ",J4:J23)
but I need it to check another column and if it has been over 9 months,
exclude that figure from the total. Any ideas???? I appreciate all the help I
have been getting here.

Hello,

With two or more criteria it is often easier to use SUMPRODUCT. I put
dates to check in N4:N8 and applied this formula:

=SUMPRODUCT(--(M4:M8="JJ"),--(N4:N8>TODAY()-274),(J4:J8))

"274" is an approximation for 9 months, but might be close enough for
your needs.