Good Afternoon:
I am trying to write a formula that will count items in a column that have met one or more criteria in corresponding column, but without counting those items twice. A simple to table to illustrate is below. As it is laid out, I would look to count 4 total items (A, B, C, E) since they meet one or more of the criteria. D would not be counted. In my real life data set, the columns are marked with a "1" just like the illustration below.
Any suggestions?
Thanks
<tbody>
</tbody>
I am trying to write a formula that will count items in a column that have met one or more criteria in corresponding column, but without counting those items twice. A simple to table to illustrate is below. As it is laid out, I would look to count 4 total items (A, B, C, E) since they meet one or more of the criteria. D would not be counted. In my real life data set, the columns are marked with a "1" just like the illustration below.
Any suggestions?
Thanks
Item | Criterion 1 | Criterion 2 | Criterion 3 | Criterion 4 |
A | 1 | |||
B | 1 | |||
C | 1 | 1 | ||
D | ||||
E | 1 | 1 | 1 |
<tbody>
</tbody>