Need a little help with this one please. I think the blank cell part is stumping me.
So I need to count the # of events an employee managed by event type within a date range (for the whole month) and that have not been cancelled.
I have a column for cancellations. The cell is blank if it was NOT cancelled. If it was cancelled, then in the cell there is the reason why.
Here's an example:
Date Column Name: Event Scheduled
Employee Column Name: Employee
Employee: John
Event Column Name: Event Type
Event: Birthday
Cancellation Column Name: Cancellation
I would like to count how many birthday events John managed in January 2021 that were NOT cancelled(blank). My current formula is counting everything including cancellations.
IMPORTANT: The event type may have multiple selections in the cell. This one has "birthday" and "music".
I want this to be counted and included in my birthday formula and also when I do the same for music formula. I've seen formulas where it will not include it in the count when multiple selections are in the cell.
Many thanks!
