Share via

CountIfs not working - need another solution

Anonymous
2024-08-22T18:32:24+00:00

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
Microsoft 365 and Office | Excel | For business | Windows

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.

0 comments No comments

Answer accepted by question author

HansV 462.6K Reputation points
2024-08-22T18:56:13+00:00

=(B2="Yes)+(E2="Yes)+(G2="Yes")

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful