Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! . |
#4
|
|||
|
|||
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! . |
#5
|
|||
|
|||
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! . |
#6
|
|||
|
|||
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! . |
#7
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
need to save values from a function before it changes | Excel Worksheet Functions |