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?
-
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
Check out the Formula Handbook template!
