I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the
maximum amount of outputs for any row is 7. Some only have A, some have, A,
B and C and so forth. Each output is in its own column.

Basically, i need to a count of all this data, but heres the catch. I need
to do counts like this, if a row contains A. B, C and X then count. If a row
contains A E Y G then count.

I have 8 different things that need to be tallied, and they all have
specific definitions from the 27 possible outputs that are in the columns.

I hope that this makes sense, and thanks in advance for helping me!!

-Adam

Hi,
You need to be more specific. What do you want counted and what do you not
want counted? The only thing I see is common when to count is the "A", so
always count is there is an "A"? It will appear always in the same column?

Might give us some examples of the output to count and where it is located
and some output not to count and where it is located?

David

"Adam" wrote:

I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the
maximum amount of outputs for any row is 7. Some only have A, some have, A,
B and C and so forth. Each output is in its own column.

Basically, i need to a count of all this data, but heres the catch. I need
to do counts like this, if a row contains A. B, C and X then count. If a row
contains A E Y G then count.

I have 8 different things that need to be tallied, and they all have
specific definitions from the 27 possible outputs that are in the columns.

I hope that this makes sense, and thanks in advance for helping me!!

-Adam

Ok here it goes. So in the 8 or so possible colums, i need it to count if.....
A if found by its self in a row, B is found by its self in a row, or if A
and B are found in a row anywhere. And for it to not count if none of these
are satisfied.


"David" wrote:

Hi,
You need to be more specific. What do you want counted and what do you not
want counted? The only thing I see is common when to count is the "A", so
always count is there is an "A"? It will appear always in the same column?

Might give us some examples of the output to count and where it is located
and some output not to count and where it is located?

David

"Adam" wrote:

I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the
maximum amount of outputs for any row is 7. Some only have A, some have, A,
B and C and so forth. Each output is in its own column.

Basically, i need to a count of all this data, but heres the catch. I need
to do counts like this, if a row contains A. B, C and X then count. If a row
contains A E Y G then count.

I have 8 different things that need to be tallied, and they all have
specific definitions from the 27 possible outputs that are in the columns.

I hope that this makes sense, and thanks in advance for helping me!!

-Adam

This is how I laid out the data:

12345678 Ct
a 1
b 1
ab 2
cdefgh 0
abababab 8

The formula under the Ct column is =COUNTIF(A6:H6,"a")+COUNTIF(A6:H6,"b"),
which was placed in cell I8. Maybe this will help.

David

"Adam" wrote:

Ok here it goes. So in the 8 or so possible colums, i need it to count if.....
A if found by its self in a row, B is found by its self in a row, or if A
and B are found in a row anywhere. And for it to not count if none of these
are satisfied.


"David" wrote:

Hi,
You need to be more specific. What do you want counted and what do you not
want counted? The only thing I see is common when to count is the "A", so
always count is there is an "A"? It will appear always in the same column?

Might give us some examples of the output to count and where it is located
and some output not to count and where it is located?

David

"Adam" wrote:

I have a few thousand rows Of data, each row has 1-7 outputs in the adjacent
columns. There are 27 different types of outputs. Lets just say A- Z, the
maximum amount of outputs for any row is 7. Some only have A, some have, A,
B and C and so forth. Each output is in its own column.

Basically, i need to a count of all this data, but heres the catch. I need
to do counts like this, if a row contains A. B, C and X then count. If a row
contains A E Y G then count.

I have 8 different things that need to be tallied, and they all have
specific definitions from the 27 possible outputs that are in the columns.

I hope that this makes sense, and thanks in advance for helping me!!

-Adam