I need help calculating the % of voluntary vs. Involuntary terminations by Group. The groups are in one column where the partial text re; termination is in another column.
Please see attached for example. Specifically I need to calculate what % of "Customer Solutions" has voluntary left vs. Involuntarily left
Last edited by spapay; 07-20-2021 at 01:02 PM.
Hi,
One way
=COUNTIFS(B:B,"Customer Solutions",F:F,"Vol*")/COUNTIFS(B:B,"Customer Solutions")
OTOH you might find a Pivot Table more useful - see attached.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks so much for the formula, while pivot table is probably easier, this specific problem requires I(we) create a formula.
The formula your provided is extremely helpful & very close to what I need. One slight difference I made was that it needs to be divided by any value containing text in column F as opposed to total # of customer solutions.
Final formula looks as such:
=COUNTIFS(Data!B:B,"Customer Solutions", Data!F:F,"Vol*")/COUNTIFS(Data!F:F,"*")
Thanks again for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks