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