L
Lou Aiello
I need to count the number of times something appears in two columns
across a row. For example:
A B
1 H
2 B
2 B
3 H
1 H
1 H
For example: I want to count how many times the "1H" combination
exists. (i.e. 3)
I created a third columm concatenating columns A & B and did a COUNTIF
on that new column, but thought there might be an easier way.
across a row. For example:
A B
1 H
2 B
2 B
3 H
1 H
1 H
For example: I want to count how many times the "1H" combination
exists. (i.e. 3)
I created a third columm concatenating columns A & B and did a COUNTIF
on that new column, but thought there might be an easier way.