Adding up a column of percents

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

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?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percent Function Help 11
Pivot Table Percent Question 4
Calculating weighted average of Percent Change 0
Weighting a Percent of Change 3
Excel Subtracting multiple columns from another column 3
Formula for Value 4
disable Total and/or Sub total for a single column 3
Incremental charges 2

Back
Top