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
Best Answer
-
=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.
Answers
-
=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.
-
@Carson Penticuff, that is what i have done for now just time consuming
Help Article Resources
Categories
Check out the Formula Handbook template!