View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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.