Countifs by Month

I am familiar with =COUNTIFS({Start Date}, >=DATE(2018, 10, 1), {End Date}, <=DATE(2018, 10, 31), {Classification}, ="Lost Time Injury")
Wondering if there is an easier way to get this?
This is pretty tedious when you're just looking for what happened in a particular month of the year.
Regards
Steve
Comments
-
Have you considered exporting the report or sheet and then doing a basic pivot in excel? You could use the connector to pull the data into an excel template if you wanted to create a custom report? Depending on your use, you might be able to make a more generic formula that references the date outside the cell, i.e. put the date at the top of the column, and then have a row for each type of absence?
-
=COUNTIFS({Classification}, "Lost Time Injury", {Start Date}, MONTH(@cell) = 10, {End Date}, MONTH(@cell) = 10)
Give this a try and let me know how it works for you.
-
This works thanks for that.
Steve
-
Could you use something similar to count multiple classifications?
-
You can. If you are able to give me some more details as to the layout and format of your sheet and whatnot or even some screenshots, I may be able to help you with that.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!