Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am dumb. There are a million examples almost exactly like this, but none
that I can find that is precisely the same, and I can't figure it out. The problem: Subtotaling a large data set. Say I have three columns: A B C 1. apple 3 4 2. apple 4 5 3. orang 3 2 4. cran 3 1 5. zebra 9 3 6. zebra 2 1 98. car 4 3 What I would like to do, is subtotal col "B" & "C" if "A" is the same.. So, if it is apples, sum up all the B's and put it somewhere, & sum up all the c's and put it somewhere. Is this possible, without going typing in each manually, or summing individually? Thanks a million to the genius that is most gracious to help me out! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Conditional summing with large amounts of data | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |