Thank you Frank - It works fine - I must have been doing
something wrong - Thank you and Happy Holidays
-----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!
.
|