Sumifs with multiple criteria's in a single row
Hope everything is well with you!
I've figured since you help me last time to resolve my issues to reach out and ask for more help if possible.
I've created a questioner form and as these are submitted, I would like to extract the answer on the single row. Basically count how many correct questions were answered and disregard the incorrect ones. I've try the Countifs And Has but it gave me wrong values, is this possible to count the different criteria's on a single row across? Below are the questions and answers on my questioner.
As always, thank you for your tremendous support!
Best Answers
-
Hi @Benny Velazquez,
Jumping in to help!
Yes, it's possible to count the correct answers on a single row across multiple criteria. You can use the SUM function in combination with multiple IF statements to achieve this.
Here's an example formula you can use:
=SUM(IF({Q2}= "Correct",1,0),IF({Q3}= "Correct",1,0),IF({Q4}= "Correct",1,0),IF({Q5}= "Correct",1,0),IF({Q6}= "Correct",1,0),IF({Q7}= "Correct",1,0),IF({Q8}= "Correct",1,0))
This formula checks each answer column (Q2 to Q8) and counts 1 for each "Correct" answer, and 0 for each incorrect answer. The SUM function then adds up the total count of correct answers.
You can adjust the formula to fit the specific criteria and layout of your questionnaire. Just make sure to include each answer column in the formula and adjust the "Correct" text to match your answer choices.
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
Hi J,
Thank you so much for jumping in on this subject, this formula did work and it was what I was looking for.
I am grateful! :-)
Answers
-
Hi @Benny Velazquez,
Jumping in to help!
Yes, it's possible to count the correct answers on a single row across multiple criteria. You can use the SUM function in combination with multiple IF statements to achieve this.
Here's an example formula you can use:
=SUM(IF({Q2}= "Correct",1,0),IF({Q3}= "Correct",1,0),IF({Q4}= "Correct",1,0),IF({Q5}= "Correct",1,0),IF({Q6}= "Correct",1,0),IF({Q7}= "Correct",1,0),IF({Q8}= "Correct",1,0))
This formula checks each answer column (Q2 to Q8) and counts 1 for each "Correct" answer, and 0 for each incorrect answer. The SUM function then adds up the total count of correct answers.
You can adjust the formula to fit the specific criteria and layout of your questionnaire. Just make sure to include each answer column in the formula and adjust the "Correct" text to match your answer choices.
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
-
Hi J,
Thank you so much for jumping in on this subject, this formula did work and it was what I was looking for.
I am grateful! :-)
-
@Benny Velazquez, glad you got it figured out! I've been offline for a bit, sorry I didn't get back to you.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!