View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WildWill WildWill is offline
external usenet poster
 
Posts: 64
Default SUMPRODUCT with LEFT() criteria?

Hi

I have this formula as a basis:
SUMPRODUCT(--(N3:N46="Bob"),--(J3:J46="Apple")) I need to modify the above
formula so that it will sum all instances where N3:N46 = "Bob" and where
J3:J46 contains text that starts (from the left) with the 4 characters
"Feline".