need minor Excel help

*verbster* · 01-02-2012, 10:44 AM

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.

Jawed · 01-02-2012, 10:53 AM

Create a 4th column, sub-total June and then July.

*verbster* · 01-02-2012, 11:34 AM

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....

defaultuser · 01-02-2012, 11:43 AM

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.

*verbster* · 01-02-2012, 01:23 PM

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.

defaultuser · 01-02-2012, 02:01 PM

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/sub...formula-excel/

Shows how to use it.

*verbster* · 01-02-2012, 04:35 PM

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.

defaultuser · 01-02-2012, 05:18 PM

Top row show should be header/column fields. That makes the dialog box make more sense too

01-02-2012, 10:53 AM	#2 (permalink)
Jawed Senior Member Join Date: Jul 2008 Location: TradeDirectory.com Posts: 2,134 Follow @TradeDirectory	Create a 4th column, sub-total June and then July. __________________ Trade Shows

01-02-2012, 11:34 AM	THREAD STARTER #3 (permalink)
verbster Yup. It's cold. Join Date: Jul 2005 Location: Alaska Posts: 2,785	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.... __________________ When in doubt, do the unexpected. Last edited by verbster; 01-02-2012 at 11:40 AM.

01-02-2012, 11:43 AM	#4 (permalink)
defaultuser Senior Member Join Date: May 2009 Location: internet@ctivist.com Posts: 4,790	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. __________________ A Member of: IdeationTeam.com HowToBeADomainer.com - a Domaining How To AuthorEditor.com

01-02-2012, 02:01 PM	#6 (permalink)
defaultuser Senior Member Join Date: May 2009 Location: internet@ctivist.com Posts: 4,790	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/sub...formula-excel/ Shows how to use it. __________________ A Member of: IdeationTeam.com HowToBeADomainer.com - a Domaining How To AuthorEditor.com

01-02-2012, 04:35 PM	THREAD STARTER #7 (permalink)
verbster Yup. It's cold. Join Date: Jul 2005 Location: Alaska Posts: 2,785	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. __________________ When in doubt, do the unexpected.

	NamePros Account Upgrade	Forum Sponsorship
	Take advantage of our upgraded membership levels (2 levels to choose from) so you can have MORE active sales threads, Custom Titles, A Directory Listing, Invisible Mode, Message Tracking, And MORE!

01-02-2012, 05:18 PM	#8 (permalink)
defaultuser Senior Member Join Date: May 2009 Location: internet@ctivist.com Posts: 4,790	Top row show should be header/column fields. That makes the dialog box make more sense too __________________ A Member of: IdeationTeam.com HowToBeADomainer.com - a Domaining How To AuthorEditor.com

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)