# Quiz scoring

Options
✭✭✭✭✭

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

• ✭✭✭✭✭✭
edited 06/07/23 Answer ✓
Options

=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.

• ✭✭✭✭✭✭
edited 06/07/23 Answer ✓
Options

=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.

• ✭✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!