I have this pivot table:
In column D, I'd like a formula that counts Employee Names in column C grouped by column B.
For example, in the picture above, Senior Consultant April Thomas will have the number 8 - a count of employees under her.
Is there a formula to count occupied cells in one column up until a value exists in another column?
Here's what I thought up so far and I am stuck:
In column D, I'd like a formula that counts Employee Names in column C grouped by column B.
For example, in the picture above, Senior Consultant April Thomas will have the number 8 - a count of employees under her.
Is there a formula to count occupied cells in one column up until a value exists in another column?
Here's what I thought up so far and I am stuck: