Counting cells that "contain" a text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make this formula count both "Dev" AND "Dev/RFC" in a column range?
I can't seem to get the wildcard variations (~, &, *) to work with this!

=SUMPRODUCT(('2007'!$I$2:$I$300="Quality")*('2007'!$E$2:$E$300="Improvement")*('2007'!$D2:$D$300="Dev"))

Thanks, Dave
 
Perhaps this?

=SUMPRODUCT(('2007'!$I$2:$I$300="Quality")*('2007'!$E$2:$E$300="Improvement")*(('2007'!$D2:$D$300="Dev")+('2007'!$D2:$D$300="Dev/RFC")))
or...
=SUMPRODUCT(('2007'!$I$2:$I$300="Quality")*('2007'!$E$2:$E$300="Improvement")*(('2007'!$D2:$D$300={"Dev","Dev/RFC"})))

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
 
Back
Top