You are viewing limited content. For full access, please sign in.

Question

Question

count radio button section in a collection

Forms
Updated March 23, 2021
asked on March 22, 2021

I have a radio button in a collection that has three options, Found Correct, Corrected, and Other.  I would like to total outside of the collection how many of each there were.  Can I do that?

This doesn't work:

0 0

Answer

SELECTED ANSWER
replied on March 22, 2021

Almost had it
=COUNTIF(Collection.Radio_Button,"choice 1")

Don't use row() unless you are putting the formula on a field inside the collection. That means "In the same row" so if you have another variable inside the collection, it will use values from the same row. Since your fields are outside of the collection, row() doesn't have any context. Instead, you just want the count anytime the value is set to "choice 1". 

2 0
replied on March 23, 2021

One more question.  What if it is "Other"?  How do I say NOT "choice 1", 2 or 3?

0 0
replied on March 23, 2021

I think I got it =COUNTIF(Collection_4.Radio_Button, ("= ")) seems to work.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...