countif text formula help
 

How can count the number of times part of person's name (either first or
last) in cell C84 appears in the range C84:D99? The following formula
doesn't do the trick. Any suggestions?

=COUNTIF(C84:D99,"C65")


--
JCH
------------------------------------------------------------------------
JCH's Profile: http://www.excelforum.com/member.php...o&userid=24697
View this thread: http://www.excelforum.com/showthread...hreadid=382651

Hi!

Try this:

=SUMPRODUCT((C84:C99={"John","Smith"})+(D84:D99={" John","Smith"}))

Biff

"JCH" wrote in message
...

How can count the number of times part of person's name (either first or
last) in cell C84 appears in the range C84:D99? The following formula
doesn't do the trick. Any suggestions?

=COUNTIF(C84:D99,"C65")


--
JCH
------------------------------------------------------------------------
JCH's Profile:
http://www.excelforum.com/member.php...o&userid=24697
View this thread: http://www.excelforum.com/showthread...hreadid=382651

how about this?

=COUNTA($c84:$d$99)-SUMPRODUCT((ISERROR(SEARCH(C65,$c$84:$d$99,1)))*1) +COUNTBLANK($C$84:$D$99)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=382651