Thread: sumif based on last digit of account list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted Metro Ted Metro is offline
external usenet poster
  
Posts: 29
Default sumif based on last digit of account list



=SUM((RIGHT(C6:C9,1)="1")*D6:D9)
Reply With QuoteReply With Quote