Hello,
I am trying to get a count multiple criteria. I have an basic example of my spreadsheet below. I want to know how many adults were present within each zone. How would I count the number of adults have yes in column B and then get a count of the adults who have yes in column b by zone? The zone is in column A.
<tbody>
</tbody>
I am trying to get a count multiple criteria. I have an basic example of my spreadsheet below. I want to know how many adults were present within each zone. How would I count the number of adults have yes in column B and then get a count of the adults who have yes in column b by zone? The zone is in column A.
Zone | Adults Present |
1 | yes |
2 | no |
2 | yes |
3 | yes |
4 | yes |
<tbody>
</tbody>