Jump to content

Excel Question #46563789274


Recommended Posts

I'd imagine this needs a Lookup but just wonder if there is an easier way:


Two columns, one with numerical values, the other with the category that corresponds to that value.




Column1 Column2

500 category x

100 category y

1000 category z



There's about 6 thousand rows and 40 odd categories.


What I'd like to do is get a pie chart showing the cumulated value of each category.


So, do a look up to isolate all the values for that category and sum them, or is there a more convenient method?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...