Exclude $ Amount from sum based on how many months its been
Vercingetorix.XIII wrote:
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:N8TODAY()-274),(J4:J8))
"274" is an approximation for 9 months, but might be close enough for
your needs.
|