Jump to content

Excel Question #46563789274


StevieC
 Share

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.

 

e.g.

 

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
 Share

  • Recently Browsing   0 members

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