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

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

Add a + between the COUNTIF.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

That did not work, or I could have put it in wrong. Do I just put a plus sing between "and" and the second countif? Or clear the "and" and put the + sign instead? I tried it both ways and it did not work.

• ✭✭✭✭✭✭
Options

Try something like this. (replace with your own column names)

=COUNTIF([In Stock?]:[In Stock?], 1)+COUNTIF([In Stock?]:[In Stock?], 1)

Did it work?

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

That worked thank you for your help. I appreciate it!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!