4

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't strong enough!

Improve this question
2
  • It won't let me add the picture as I need a '10 reputation!
    – MikeFallopian
    Oct 20, 2014 at 13:24
  • Try adding it now! :)
    – Dave
    Oct 20, 2014 at 13:26

1 Answer 1

Reset to default
4

Sounds like a job for pivot table!

Select the range and go to Insert - Pivot Table

For row labels, have whatever your rows are.

In the values field place your numbers, click the drop down and go to value field settings.

Now show value as and select % of total in the drop-down.

Now they are summarized by percentage of total!

click for full size image enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .