View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vercingetorix.XIII[_2_] Vercingetorix.XIII[_2_] is offline
external usenet poster
 
Posts: 30
Default exclude amount from sumif total based on how many months

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