|
| 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
September 15th, 2008, 08:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding up a column of percents
I need to know the formula for adding up a row of percents....
I am trying to find the total of 5 percetages - this is a sales increase on 5 different accounts that i need to total. 0.044 0.054 0.009 -0.021 0.036 how do i get these to total correctly in a formula that i can put in my worksheet? -- T 
|
|
#2
September 15th, 2008, 08:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding up a column of percents
There's nothing special about percents. Just use SUM.
|
|
#3
September 15th, 2008, 08:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding up a column of percents
Just add them.
"Trish" wrote in message ... I need to know the formula for adding up a row of percents.... I am trying to find the total of 5 percetages - this is a sales increase on 5 different accounts that i need to total. 0.044 0.054 0.009 -0.021 0.036 how do i get these to total correctly in a formula that i can put in my worksheet? -- T
|
|
#4
September 15th, 2008, 08:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding up a column of percents
if your data is in row 2, say B2:F2, a simple SUM() will work.
=sum(b2:f2) Is your problem a little more complicated than this, perhaps? "Trish" wrote: I need to know the formula for adding up a row of percents.... I am trying to find the total of 5 percetages - this is a sales increase on 5 different accounts that i need to total. 0.044 0.054 0.009 -0.021 0.036 how do i get these to total correctly in a formula that i can put in my worksheet? -- T
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
