count values

PYI

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

sheet and form view.pdf

PYI

=COUNTIFS(A@row:A@row, 1, B@row:B@row, 1)>0 ,"Green"

i have tried something like this but it dint worked out

Genevieve P.

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