Solved

Pivot Table???  Excel 2010

Posted on 2016-08-17
4
19 Views
Last Modified: 2016-09-07
I need to total data when certain cells match...let me explain:

A      B     C
160      3      01100040100310
686      25      01100040100315
200      1      01100040102110
569      19      01200010100105
160      5      01100040100310
686      25      01100040100315
200      1      01100040102110
569      19      01200010100105
160      2      01100040100310
686      25      01100040100315
200      1      01100040102110
569      19      01200010100105


These are my 3 columns.

Everywhere the value in column C exists I need to cumulatively add the value in column B

For example....I would want to know that 01100040100310 had a total value of 10.

Is there a formula to do this?  I used a pivot table to get close but then I need to sort by the total in whatever new sheet I create.
0
Comment
Question by:joemckamey
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
Serena Hsi earned 300 total points (awarded by participants)
ID: 41760343
In this example:
A = price
B = count
C = productID

I created a simple pivot that just counts the unique occurrences of column C and added a custom sort option to how the table displays.

In the Pivot Table, select the row's dropdown options and choose "More sort options"

Then, select Ascending or Descending on the total count field:
pivot1_sort_by_rowcount.PNG
Does this help?
1
 

Expert Comment

by:Member_2_7972293
ID: 41761533
Let me play with that...thanks for the input.
0
 
LVL 17

Assisted Solution

by:xtermie
xtermie earned 200 total points (awarded by participants)
ID: 41762475
You could use the subtotal feature, without creating pivot tables.
Also a SUMIF or SUMIFs formula would work if you had the list of unique identifiers somewhere on the sheet.
Can you post a sample of your data in Excel and where you'd like the results to be?
0
 
LVL 17

Expert Comment

by:xtermie
ID: 41787474
Good options and comments provided by experts, author never responded
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now