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

Find more posts tagged with

Formulas

Sheet Summary

Countif

Accepted answers

All comments

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-

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.