Need help adding an AND clause to a countif formula

I have a metric sheet with a list of customers that counts the number of orders in an order sheet

The formula I am using is:

=COUNTIF({Analyst Request Tracker with Form Range 5}, Category52)

Need to add an AND clause based on status being equal to "In Progress, or "Not Started" (column located in the Analyst Request tracker with form sheet)

Any assistance appreciated.

Find more posts tagged with

Accepted answers

All comments

Shanky Paul

Try the below one:

=COUNTIFS({Analyst Request Tracker with Form Range 5}, Category52, {Analyst Request Tracker with Form Range Status}, "In Progress") + COUNTIFS({Analyst Request Tracker with Form Range 5}, Category52, {Analyst Request Tracker with Form Range Status}, "Not Started")

ClanMcDe

https://community.smartsheet.com/discussion/comment/448607#Comment_448607

Hi Shanky,

I tried the formula and it only seems to count the items if they are "In Progress"

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.