counting two different values

[TLAngelo]

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

 

[Don Guillett]

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

 

[Pete_UK]

You could do it this way:

=COUNTIF(A:A,"PD/JD") + COUNTIF(A:A,"JD/PD")

Assumes your initials are in column A.

Hope this helps.

Pete

 

[TLAngelo]

Thank you Pete!

Tania

You could do it this way:

=COUNTIF(A:A,"PD/JD") + COUNTIF(A:A,"JD/PD")

Assumes your initials are in column A.

Hope this helps.

Pete

 

[TLAngelo]

Thank you Don.

Tania

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Pete_UK]

You're welcome, Tania - thanks for feeding back.

Pete