Formula that calculates the multiple choices chosen from a drop-down list

HYG_Support

I need a formula that calculates the choices from a multiple selections row.

I am currently using the formula

=COUNTIF({Link Access}, "Overdue Report")

Paul Newcome

Try a HAS function:

=COUNTIF({Link Access}, HAS(@cell, "Overdue Report"))

Paul Newcome

Try a HAS function:

=COUNTIF({Link Access}, HAS(@cell, "Overdue Report"))

HYG_Support

Thank you that works.

HYG_Support

How can I add a status command behind this formula?

=COUNTIF({Link Access}, HAS(@cell, "Overdue Report"))

Paul Newcome

I'm not sure I follow. What exactly do you mean by adding a status command behind the formula?

HYG_Support

I need a formula that calculates the choices from a multiple selections row but also filters by status.

Paul Newcome

In that case you would use a COUNTIFS function (with the "S" on the end) to allow for multiple range/criteria sets and then just follow the same syntax of range comma criteria.

=COUNTIFS(range 1, criteria 1, range 2, criteria 2)