counting two different values
 

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

counting two different values
 

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

counting two different values
 

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

On Jul 2, 9:36*pm, TLAngelo
wrote:
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

counting two different values
 

Thank you Pete!

Tania

"Pete_UK" wrote:

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

On Jul 2, 9:36 pm, TLAngelo
wrote:
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

counting two different values
 

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

counting two different values
 

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

Pete

On Jul 2, 9:57*pm, TLAngelo
wrote:
Thank you Pete!

Tania