Counting cells that "contain" a text string

D

Dave

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
 
R

Ron Coderre

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)
 
Top