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.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!