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

Adding up a column of percents
 

There's nothing special about percents. Just use SUM.

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

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