Create a small table in Google Sheets using COUNTIFS
Budget: $10 – $30 AUD
I need a small table to count the number of occurrences in one column, depending on the values in another column.
Concretely, we have a Google sheet with activities by date (Excel example attached). For each activity, one employee is responsible.
I'd like a count how many activities each employee is responsible for in by month.
There are two more conditions: the sheet also contains rows with events that are 'Cancelled' or 'TBC' (both indicated in the same column) - those rows need to be excluded from the total.
The range is dynamic: in 2023 it will start with the events for that year but new events are added all the time.
Attached the file downloaded into Excel. I'll give access to the winning freelancer to access a Google Sheets file to complete the table.
Freelancer forced me to choose 2 skills needed for this project but I assume only advanced Excel/G Sheets is required.
Concretely, we have a Google sheet with activities by date (Excel example attached). For each activity, one employee is responsible.
I'd like a count how many activities each employee is responsible for in by month.
There are two more conditions: the sheet also contains rows with events that are 'Cancelled' or 'TBC' (both indicated in the same column) - those rows need to be excluded from the total.
The range is dynamic: in 2023 it will start with the events for that year but new events are added all the time.
Attached the file downloaded into Excel. I'll give access to the winning freelancer to access a Google Sheets file to complete the table.
Freelancer forced me to choose 2 skills needed for this project but I assume only advanced Excel/G Sheets is required.