IT.COM

Need minor Excel help

Spaceship Spaceship
Watch
Impact
3,414
Have three columns in Excel 2010.

june 22 $1.22
june 34 $0.89
june 45 $2.22
july 12 $3.33
july 34 $1.65
july 45 $0.99

How do I consolidate/merge to just make it
june 101 $4.33
july 91 $5.97

Thanks.
 

Attachments

  • excel question.jpg
    excel question.jpg
    23 KB · Views: 189
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
Create a 4th column, sub-total June and then July.
 
1
•••
Thanks. That works. However, I should have mentioned I have around 2000 entries in the three colums, with at least half like the example. Using the subtotal, it appears I would have to enter the formula parameters for each set of alike names in column A?

I tink just highlighting and clicking autoSum will probably work for now. Not the most elegant solution, but....
 
Last edited:
0
•••
I have 2007

Just highlight the all three columns and hit the "sub-total" button (On the DATA tab)

Then you have collapse boxes on the left to hide/show detail.
 
1
•••
What you described seems simple enough, but I must be making a basic mistake somewhere. The subtotal doesn't seem to tally the two adjacent cells. And it inserts two lines in the original table. I've attached a couple of screen shots.

I thought maybe the "consolidate" feature (using "sum") would work, but I can't seem to get the "reference" field right. The description seems right, but maybe I'm thinking wrong.
 

Attachments

  • beze 1.jpg
    beze 1.jpg
    98.6 KB · Views: 154
  • beze 2.jpg
    beze 2.jpg
    25 KB · Views: 158
0
•••
Select both rows you want to subtotal in the subtotal options.

There's an issue with it entering subtotals in the row?

You can use the outliner on the left (Plus / Minus buttons... or click 1,2,3- to collapse to show subtotals only, grand totals, or detail.

Here's the first link I found on google:

http://chandoo.org/wp/2010/02/09/subtotal-formula-excel/

Shows how to use it.
 
1
•••
It almost works, but for some reason it doesn't total in the top number. For example, if column B had

10
15
20
25

it shows the subtotal as 60 instead of 70....just leaves the 10 out of the sum. Does that in both columns.
 
0
•••
Top row show should be header/column fields. That makes the dialog box make more sense too :)
 
1
•••
Back