Function HELP!

[Karen]

I have a range of cells (J357) 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!

 

[Frank Kabel]

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")+(P1100="Reject")>0))

 

[Karen]

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.

 

[Karen]

Thank you Frank - It works fine - I must have been doing
something wrong - Thank you and Happy Holidays

 

[Frank Kabel]

Hi Karen
glad it works for you.

 

[Karen]

I meant to ask - In the formula, what does the "--" mean
in SUMPRODUCT(--
Thank you

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCTWizard.html