Can you have two countif formulas in one cell?

Options

I created a quiz in forms, and I am trying to capture all the right answers in the row to one cell. I have 7 questions each in their own column. When I try to use the countif formula to capture if the answer to question one is right it works and puts a 1 in the questions right column. When I go to add another formula two capture the right answer for question 2 it wont let me do it. Is there a formula to capture each right question in the same cell for that row? Essentially, I need it to capture all the right answers in the row in my Questions Right for that row.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!