Need help adding an AND clause to a countif formula

ClanMcDe

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.

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"