I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula
that says if column 3=N, and there is an "x" in column 1 or 2 count "x"
seperatly in each column. (ie. total column would be N, E S,W, then each row
would have a total for "x"'s in that particular row. Same thing, if Column
3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and
I'm giving up. Can any of you nice folks help?
--
Thank you for you help
MO
Albany, NY

Your statement of the problem isn't too clear but, assuming the Ns, Es, etc
are in column C and the Xs are in columns A & B, you can use this count the
entries in col A

=SUMPRODUCT(--(A1:A100="X"),--(C1:C100="N"))

and this for col B

=SUMPRODUCT(--(B1:B100="X"),--(C1:C100="N"))




"MO" wrote:

I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula
that says if column 3=N, and there is an "x" in column 1 or 2 count "x"
seperatly in each column. (ie. total column would be N, E S,W, then each row
would have a total for "x"'s in that particular row. Same thing, if Column
3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and
I'm giving up. Can any of you nice folks help?
--
Thank you for you help
MO
Albany, NY

Thank you for your help Duke. Your assumptions are correct; however, it does
not work. I need a count of how many x's are in column A for each(N E S W)
and I need a count of how many x's are in column B for the same. I know I
have to list N E S W somehwhere and then I need a count for x's for each to
appear.
--
Thank you for you help
MO
Albany, NY


"Duke Carey" wrote:

Your statement of the problem isn't too clear but, assuming the Ns, Es, etc
are in column C and the Xs are in columns A & B, you can use this count the
entries in col A

=SUMPRODUCT(--(A1:A100="X"),--(C1:C100="N"))

and this for col B

=SUMPRODUCT(--(B1:B100="X"),--(C1:C100="N"))




"MO" wrote:

I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula
that says if column 3=N, and there is an "x" in column 1 or 2 count "x"
seperatly in each column. (ie. total column would be N, E S,W, then each row
would have a total for "x"'s in that particular row. Same thing, if Column
3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and
I'm giving up. Can any of you nice folks help?
--
Thank you for you help
MO
Albany, NY

On Fri, 10 Mar 2006 06:41:29 -0800, MO
wrote:

Thank you for your help Duke. Your assumptions are correct; however, it does
not work. I need a count of how many x's are in column A for each(N E S W)
and I need a count of how many x's are in column B for the same. I know I
have to list N E S W somehwhere and then I need a count for x's for each to
appear.

Could you post some typical data in the layout you have, and indicate
what you expect to see as a result. That would enable us to better
understand your requirement.

Rgds



Richard Buttrey
__

Sorry for the confusion. Here's what I'm trying to do.
Col 1 Col 2 Col 3
x N
x E
x S
x W
x S
x E
x N
x N
x N
x E


N 0 0
E
S
W


--
Thank you for you help
MO
Albany, NY


"Richard Buttrey" wrote:

On Fri, 10 Mar 2006 06:41:29 -0800, MO
wrote:

Thank you for your help Duke. Your assumptions are correct; however, it does
not work. I need a count of how many x's are in column A for each(N E S W)
and I need a count of how many x's are in column B for the same. I know I
have to list N E S W somehwhere and then I need a count for x's for each to
appear.

Could you post some typical data in the layout you have, and indicate
what you expect to see as a result. That would enable us to better
understand your requirement.

Rgds



Richard Buttrey
__

On Fri, 10 Mar 2006 07:33:00 -0800, MO
wrote:

Sorry for the confusion. Here's what I'm trying to do.
Col 1 Col 2 Col 3
x N
x E
x S
x W
x S
x E
x N
x N
x N
x E


N 0 0
E
S
W

Thanks,

With the data above in A10:C10, enter N, E, S, W into E1:E4

Then put
=SUMPRODUCT((A$1:A$10="x")*($C$1:$C$10=$E1))
into F1 and copy to F1:G4

HTH

Richard Buttrey
__

What exactly do you mean by "it does not work"?

"MO" wrote:

Thank you for your help Duke. Your assumptions are correct; however, it does
not work. I need a count of how many x's are in column A for each(N E S W)
and I need a count of how many x's are in column B for the same. I know I
have to list N E S W somehwhere and then I need a count for x's for each to
appear.
--
Thank you for you help
MO
Albany, NY


"Duke Carey" wrote:

Your statement of the problem isn't too clear but, assuming the Ns, Es, etc
are in column C and the Xs are in columns A & B, you can use this count the
entries in col A

=SUMPRODUCT(--(A1:A100="X"),--(C1:C100="N"))

and this for col B

=SUMPRODUCT(--(B1:B100="X"),--(C1:C100="N"))




"MO" wrote:

I have 3 colums of data with multiple rows. the first two columns contain
"x"'s while the third contains 1 alphabet. I'm trying to set up a formula
that says if column 3=N, and there is an "x" in column 1 or 2 count "x"
seperatly in each column. (ie. total column would be N, E S,W, then each row
would have a total for "x"'s in that particular row. Same thing, if Column
3=N, if Column 3=S, if Column 3=W. I've been trying for days to get this and
I'm giving up. Can any of you nice folks help?
--
Thank you for you help
MO
Albany, NY