ExcelBanter - View Single Post

TLAngelo

Thank you Don.

Tania

"Don Guillett" wrote:

try this idea.
=SUMPRODUCT(--(A2:A22={"a","b"}))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TLAngelo" wrote in message
...
I have a worksheet where I track who processed documents among other
things.
Normally they enter their ititials on the worksheet and I can count how
many
of each ititial is in that column. If two people work on one document,
they
may enter their initials JD/PD or PD/JD for example. I want to count how
many times either JD/PD or PD/JD exists in the column.

Thanks,

Tania