Excel Part Deux

[transparent]

Is it possible to aggregate data in Excel?

I now have a table which displays:

Name Paper ImpactFactor

Rick Sun 1
James Star 3
Tom Guardian 6
Rick Independent 9

I want to create another spread sheet that displays Name and ImpactFactor, however, in the case where a person is listed twice, I will need to Sum the ImapctFactors, so from above:


Name ImpactFactor

Rick 10 (summed from values 1 & 9)
James 3
Tom 6

Is this possible. I have been told by a collegue that it isnt.

 

[xlbo]

look in the help files for "Pivottable"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Lilliabeth]

=SUMIF(A1:A4,"rick",C1:C4)

 

[AnotherHiggins]

Have a look at Data > Subtotals

[tt]_____
[blue]-John[/blue][/tt]

"Patriotism is your conviction that this country is superior to all other countries because you were born in it."
[tab]-George Bernard Shaw

Help us help you. Please read FAQ181-2886 before posting.

 

[xlhelp]

What Lilabeth has suggested will produce duplicate results. I would change the formula a little to
=SUMIF($A$1:$A$4,A1,$C$1:$C$4) and then copy formula down.

What anotherhiggins has suggested assumes that the two instances fo "rick" are together.

http://www.geniusmedia.ca

 

[xlbo]

would take about 10 seconds flat using a pivottable

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xlhelp]

And of course, Geoff is right. Pivot table would be the ideal solution.

Geoff, after all these years, you probably know that I am too quick to press that submit button. As soon as I had clicked on it I said to me-self "d... forgot to mention the pivot tables"

http://www.geniusmedia.ca

 

[Lilliabeth]

Is this possible. I have been told by a collegue that it isnt.

With no more than a slight modification, such as sorting, any of the methods described here will work.
Sumproduct would also work. (I know that's overkill, but it would work.)

 

[xlbo]

[LOL] xlhelp - too many times I've done far too similar !!

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question