Are you wanting a count of how many times a specifc letter appears with a
specific name, or just how many letters?

The first:
=SUMPRODUCT(($A$1:$A$100="ClientName")*($B$1:$B$10 0="d"))

The latter:
=SUMPRODUCT(($A$1:$A$100="ClientName")*1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Cassie" wrote:

I have client names in column A and the letters d, hh, h, or db in column B
to designate their status. There are multiple occurences for some clients in
the spreadsheet. I want a formula that will count a letter once per client
like the SUMIF function, not once for each occurence of the letter like the
COUNTIF function. Let me know if someone needs clarification or has an
answer to my dilemma. Thanks!