Hello,
Apologies if this is repeated, I've tried searching for an answer but have not found anything.
I am looking for a way to calculate a percentage based on the number of cells with a value
example
<tbody>
</tbody>
Thank you!
Apologies if this is repeated, I've tried searching for an answer but have not found anything.
I am looking for a way to calculate a percentage based on the number of cells with a value
example
Sales person 1 | Sales person 2 | Sales person 3 | Sales person 1 % | Sales person 2 % | Sales person 3% |
100 items | 150 items | =average of number of cells with data, in this case only salespersons 1 and 2 In this case = 40% | =average of number of cells with data, in this case only salespersons 1 and 2 In this case = 60% | =determine that no there is no data for salesperson #3 , therefore leave blank |
<tbody>
</tbody>
Thank you!