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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sales person 1 [/TD]
[TD]Sales person 2[/TD]
[TD]Sales person 3[/TD]
[TD]Sales person 1 %[/TD]
[TD]Sales person 2 %[/TD]
[TD]Sales person 3%[/TD]
[/TR]
[TR]
[TD]100 items[/TD]
[TD]150 items[/TD]
[TD][/TD]
[TD]=average of number of cells with data, in this case only salespersons 1 and 2

In this case = 40% [/TD]
[TD]=average of number of cells with data, in this case only salespersons 1 and 2

In this case = 60% [/TD]
[TD]=determine that no there is no data for salesperson #3 , therefore leave blank[/TD]
[/TR]
</tbody>[/TABLE]

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