If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|