count values
HI,
- I have a form with checklist info for different types(Type 1 , Type 2), also in the form i specified minimum nr of selection for each types.
- After submission i want to check whether submitted info has the valid nr of selection r not
- Ex)For Type 1 person has to select minimum 1 checkbox
- For Type 2 person has to select minimum 3 checkbox
After submission i want to count these checkboxs for type 1 and type2
if the person selected minium1 checkbox for type 1 then the type1count column has to show green
if the person selected minimum 3 checkbox for type 1 the type2count column has to show green
i am bit confused with the formulas , can anyone please
help me out
Answers
-
=COUNTIFS(A@row:A@row, 1, B@row:B@row, 1)>0 ,"Green"
i have tried something like this but it dint worked out
-
Hi @PYI
You're close with your formula! However instead of having each column be its own range, you can create a range from A to B, like so:
A@row:B@row
Then you can look between these cells to see how many checked boxes there are:
COUNTIF(A@row:B@row, 1)
Based on the number you can display different options, such as "Green", but this would need to be in an IF Statement.
Try something like this:
=IF(COUNTIF(A@row:B@row, 1) > 0, "Green", "Red")
You can do the same thing for your other columns, but I would change the order so if it's less than a number show Red, otherwise Green:
=IF(COUNTIF(C@row:E@row, 1) < 3, "Red", "Green")
Does that make sense? Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!