Percentage equal distribution of products, at a constant number of 1

[K0st4din]

Hello, everyone,
I've been trying for several days to put together some formula that might work for me, but somehow I can't.
I hope someone can help me with my dilemma.
I will attach an example.
I have a table with many rows and columns, but I will extract a small part for the example.
In the first column I have names. In the first row I have product names (5, 50 or 500 doesn't matter). Under these products, for each name and for certain products, there is a set number of 1 (one name may have 6 - units, and another 3, a third party may have 9 - units - it is different).
What I'm trying to do is see (calculate) according to the 1's how many there are for each name and divide them by 100% to get an average number in % and distribute it to the adjacent columns which are absolute a copy of the first columns with the product names.
I hope I have explained correctly what I am trying to do.
I remain available if you have any questions and thank you for your assistance.

	Praskovi	Dini	qbyklki	analgin	aspirin	syrce	krusha			Praskovi	Dini	qbyklki	analgin	aspirin	syrce	krusha	%
ivan ivanov	1		1	1						33.3%		33.3%	33.3%				100.0%
petko petkov	1	1		1	1	1				20.0%	20.0%		20.0%	20.0%	20.0%		100.0%
nikolai nikolov		1	1	1		1	1				20.00%	20.00%	20.00%		20.00%	20.00%	100.0%
jon jon	1	1	1	1	1	1	1			14.28%	14.28%	14.28%	14.28%	14.28%	14.28%	14.28%	100.0%

 

[Z51]

In K2 (under "Praskovi"), you should be able to use

=IF(B2<>"",B2/SUM(B2:H2),"")

Then fill that down and across to the right.

 

[K0st4din]

Hello,
thank you very much for the quick reply.
That's cool, now I just have to figure it out by putting it in the first column, if I drag it down it's fine, but when I go to the 2nd, 3rd columns, I have to put $$ so it doesn't change my range of cells.
But it's cool, I'll just have two formulas.
Be alive and well.
Thanks again!

=IF(B2<>"",B2/SUM(B2:H2),"") and 2nd =IF(B2<>"",B2/SUM($B$2:$H$2),"")

 

[Z51]

You can just use the one with dollar signs in the first cell, too. No need to have different formulas.

 

[K0st4din]

You can just use the one with dollar signs in the first cell, too. No need to have different formulas.

Hi, you want to say

=IF($B2<>"",B2/SUM(B2:H2),"")

 

[Z51]

No, put this in the first cell, then drag down/across.

=IF(B2<>"",B2/SUM($B2:$H2),"")