Calculate percentage based on number of cells with a value

[Charles_]

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

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!

 

[Charles_]

Fluff - Would you be so kind and tell me how to, when using =B2/AGGREGATE(9,6,B2,D2,F2) show blank or 0, either works, cells when there is no value to calculate and remove the #DIV/0! issue, please?

Thanks!

 

[Fluff]

To make it "blank" use
=IFERROR(B2/AGGREGATE(9,6,B2,D2,F2),"")
or replace the "" with 0 to show 0

 

[Charles_]

Brilliant, thanks again!!

 

[Fluff]

You're welcome