percentages
 

I have forty clients, 10 have blue shirts, 3 have blue shirts, 5 have 7 green
shirts,15 have white shirts, I need to calculate the total percentage at the
end of the month, I need to show the percentage change every time I input an
additional shirt for any given client

this is an example, thanks in advance

percentages
 

In cells A1 thru A5 enter:
10
3
5
7
15

In cell A6 enter:
=SUM(A1:A5)
In B1 thru B5 enter:
=A1/$A$6
=A2/$A$6
=A3/$A$6
=A4/$A$6
=A5/$A$6
and format as pecentage. We see:

10 25.00%
3 7.50%
5 12.50%
7 17.50%
15 37.50%
40

now just update A1 thru A5 on a monthly basis.

--
Gary''s Student - gsnu200842


"Edgar G" wrote:

I have forty clients, 10 have blue shirts, 3 have blue shirts, 5 have 7 green
shirts,15 have white shirts, I need to calculate the total percentage at the
end of the month, I need to show the percentage change every time I input an
additional shirt for any given client

this is an example, thanks in advance