Hello. I'm trying to count how many days I worked remotly, how many days I
was sick and how many vacation days I took each month.
Month Date Type
Jan 5 Work Remotly
Jan 6 Sick Day
Jan 23 Work Remotly
Feb 11 Sick Day
Mar 16 Work Remotly
Mar 17 Vacation Day
In this example, this would be the result:
Jan Feb Mar Type
2 0 1 Work Remotly
1 1 0 Sick Day
0 0 1 Vacation Day
What would the formula be to get those results? Thanks! Fatima