Counts if with multiple conditons

laurie.sather47706

Help!

Trying to get a count if line items that do not have a column marked resolved and have a issue type of Reports Missing.

=COUNTIFS({Aimbridge Report Issues Range 2}, "Reports Missing",{Aimbridge Report Issues Range 2}, 0)

I am sure it is simple...but I an not figuring it out and need help!

Find more posts tagged with

Formulas

Comments

Nic Larsen

The formula above looks like both conditions are using the same range. Should the 2nd range be pointed at a different column with a different range name?

Paul Newcome

My thoughts exactly. Double check the ranges. There should be 2 different ranges if one is looking for text and another is looking for a checkbox.

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…