Question

tmichelle068

I have two columns on a form that the answer can be a number or a multiple choice answer. Is there a way to create a formula to count how many times the answer of those is not what we want it to be?

Example: The question on the form states "How many minutes was the huddle?" I have it set up to be a number-only response, and anything over 20 is considered a violation. What kind of formula could I use to count how many over 20 minutes there are?

Kimberly Loveless

you could use a countif formula something like...

=COUNTIF([Huddle Time]:[Huddle Time], >20)

Where "Huddle Time" is the column header for that column in the sheet.

If you are using a multi-select column type for something similar you would have to incorporate the CONTAINS function as well.