A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
=(B2="Yes)+(E2="Yes)+(G2="Yes")
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm sure this is very simple, but I cannot figure it out.
I need count of how many questions in a range were answered "yes" for each ID#, and also how many were answered "No". However, some of the questions in the range do not apply and must be excluded.
For example: how would I count the number of Yes answers in Columns B, E & G for ID#1? I thought CountIfs would be the solution, but I cannot get it to work. Thanks!
| A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|
| ID | Question 1 | Question 2 | Question 3 | Question 4 | Question 5 | Question 6 |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | Yes | Yes | No | Yes | No | Yes |
| 2 | Yes | No | Yes | No | Yes | No |
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author