Thread: Exclude $ Amount from sum based on how many months its been
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vercingetorix.XIII[_2_] Vercingetorix.XIII[_2_] is offline
external usenet poster
  
Posts: 30
Default Exclude $ Amount from sum based on how many months its been
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.
Reply With QuoteReply With Quote