Thread: Can I use Sumproduct with the LEFT Function?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Can I use Sumproduct with the LEFT Function?
It's a paren thing, try this:

=SUMPRODUCT((LEFT($F$4:$F$1004,2)="SM")*($B$4:$B$1 004))

Tom
Reply With QuoteReply With Quote