Function HELP!

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

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