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!

Find more posts tagged with

Accepted answers

J Tech

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.

Benny Velazquez

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

All comments

J Tech

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.

Benny Velazquez

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

@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

@Lucas Rayala, no problem brother!

Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.