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
|