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!