CountIFS & Counting Dates

Hi All,

I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I need to return the value for the total number of existing devices installed.

Any help is greatly appreciated!

Find more posts tagged with

Healthcare

Formulas

IT & Operations

Project Management

Comments

Genevieve P.

Hi Chris,

To create a COUNTIFS formula, with multiple criteria, you just need to list each range and criteria within your brackets.

In this instance, you can look to see if the Device column has "New" and the Date column is not blank. Use <> for "is not", and two quotation marksl, "", to represent "blank".

For example:

=COUNTIFS([Date Installed]:[Date Installed], <>"", Device:Device, ="New")

Cheers,

Genevieve

Screen Shot 2019-12-08 at 12.29.19 PM.png

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…