Since "Feline" = 6 characters (not 4)
Try: =SUMPRODUCT(--(N3:N46="Bob"),--(LEFT(J3:J46,6)="Feline"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"WildWill" wrote:
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"