In my spreadsheet I have a list of people. In column A I have got their name, in column B the society they work for, in column C how many times they held a positionX, in column D how many times they held a positionY, in column E how many times they held a positionZ. Not all of them held a position X, Y or Z. They could have held one of them, two of them, all of them or none.
I need to know how many of them held a position (no matter which one, how many times or how many of them), divided by society. Is that possible?
Solved by I. L. in 29 mins