Hi Frank,

Yes I have - Although, I used all the formulas that were
posted and none of them worked. I wasn't sure if I were
explaining it correctly. I'll try your formula right now
and get back to you. Thank you for your help.
-----Original Message-----
Hi Karen
question sounds familiar. I think you already received
some answers for
this. But anyway. One way:
=SUMPRODUCT(--((J1:J100="Reject")+(M1:M100="Reject")+
(P1:P100="Reject")0))

"Karen" wrote:

I have a range of cells (J3:P57) that the
word "Reject"
may appear in. In an individual row, "Reject" may
appear
in column J,M or P only. If it appears in any one of
those columns, I want to count the number of times it
appears. But it can only be counted once in each
row/record. If it appears in column J & P, count it
once. If it appears, in column J,M & P, count it once.

HELP!

.