Using COUNTIFS with AND in Summary Sheet

IES

Current Formula is for # Enrolled

=COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course")

I need a formula for Enrolled AND # Late Status Red X

Bassam Khalil

Hi @IES,

please try the following formula:

=COUNTIFS(Enrolled:Enrolled, 1, [Status]:[Status],"No")

Anjanesh Vaidya

Hi IES,

As you want one more condition in the formula, you can provide another range and criterion in the formula of countifs.

Please refer following link-

COUNTIFS Function | Smartsheet Learning Center

https://help.smartsheet.com/function/countifs

Counts the number of times all given conditions in their respective ranges are met.

If you are still facing issues, please share some screenshots for the context where you are trying to apply the formula with the fields required in it.

Thank you

Anjanesh Vaidya