Sumifs with multiple criteria's in a single row

Options

@Lucas Rayala

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

  • J Tech
    J Tech ✭✭✭✭✭
    Answer ✓
    Options

    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!
  • Benny Velazquez
    Benny Velazquez ✭✭✭✭
    Answer ✓
    Options

    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

  • J Tech
    J Tech ✭✭✭✭✭
    Answer ✓
    Options

    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!
  • Benny Velazquez
    Benny Velazquez ✭✭✭✭
    Answer ✓
    Options

    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! :-)

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭
    Options

    @Benny Velazquez, glad you got it figured out! I've been offline for a bit, sorry I didn't get back to you.

  • Benny Velazquez
    Benny Velazquez ✭✭✭✭
    Options

    @Lucas Rayala, no problem brother!


    Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!