Quiz scoring

Need a proper formula to count each correct answer on a row. with inspections it is safe or at risk which is easy to count, but i can figure out how to count each column with different answer.

I came up with this =COUNTIFS([Reason forklift safety is important]@row, "D. All of the above", [Primary sources of fuel]@row, "D. All of the above", [Operator is not required to wear seat belt]@row, "E. The operator is always required to wear their seat belt") but equals 1 not 3

please help @Paul Newcome

Find more posts tagged with

Accepted answers

Carson Penticuff

=COUNTIF([Primary sources of fuel]@row, "D. All of the above") + COUNTIF([Operator is not required to wear seat belt]@row, "E. The operator is alwa...) + COUNTIF([major difference between car and forklift]@row, "D. All of the above") + ...

You should be able to finish the formula based on this. This will work, but this will be a very long formula. Maybe someone can suggest a more concise approach.

COUNTIFS is not meant to count multiple things. Its purpose is to verify that something meets multiple criteria before being counted.

All comments

Carson Penticuff

You should be able to finish the formula based on this. This will work, but this will be a very long formula. Maybe someone can suggest a more concise approach.

COUNTIFS is not meant to count multiple things. Its purpose is to verify that something meets multiple criteria before being counted.

Kyle Black

@Carson Penticuff, that is what i have done for now just time consuming

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.