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!
Comments
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!