Function HELP!
 

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="R eject")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!

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!

.

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!

.

Hi Karen
glad it works for you.

--
Regards
Frank Kabel
Frankfurt, Germany

"Karen" schrieb im Newsbeitrag
...
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!

.

I meant to ask - In the formula, what does the "--" mean
in SUMPRODUCT(--
Thank you
-----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!

.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Karen" schrieb im Newsbeitrag
...
I meant to ask - In the formula, what does the "--" mean
in SUMPRODUCT(--
Thank you
-----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!

.