software

I have a table like this (original cotains a row a 4000 cells)
CARNUMBERTOTAL
Mazda1
Mazda7
Mazda8
Volvo4
Volvo5
Skoda5
Skoda4
Skoda7How do i get a sum of cells with the same name, so you get something
like this.

CARNUMBERTOTAL
Mazda116
Mazda7
Mazda8
Volvo49
Volvo5
Skoda516
Skoda4
Skoda7--
Mark J
------------------------------------------------------------------------
Mark J's Profile: www.excelforum.com/member.php...oamp;userid=30738
View this thread: www.excelforum.com/showthread...hreadid=504042On Mon, 23 Jan 2006 09:39:11 -0600, Mark J
gt; wrote:

gt;
gt;I have a table like this (original cotains a row a 4000 cells)
gt;
gt;
gt;
gt;CARNUMBERTOTAL
gt;Mazda1
gt;Mazda7
gt;Mazda8
gt;Volvo4
gt;Volvo5
gt;Skoda5
gt;Skoda4
gt;Skoda7
gt;
gt;
gt;How do i get a sum of cells with the same name, so you get something
gt;like this.
gt;
gt;CARNUMBERTOTAL
gt;Mazda116
gt;Mazda7
gt;Mazda8
gt;Volvo49
gt;Volvo5
gt;Skoda516
gt;Skoda4
gt;Skoda7

To replicate your results, and this assumes that CAR is sorted as you show, and
the table is in A1:Cn. CAR and NUMBER are NAME'd ranges.

C2:=IF(A2lt;gt;A1,SUMIF(CAR,A2,NUMBER),quot;quot;)

Copy/Drag down as far as needed.

You should also look at the

Data/Subtotals and Data/Pivot Table wizards for alternate methods of doing
this.

In particular, the Pivot Table will be of value if CAR is not a sorted list.--ron

Names in Column A,
Numbers in Column B,
Enter this in C1, and copy down as needed:

=IF(A1lt;gt;A2,SUMIF($A$1:A1,A1,$B$1:B1),quot;quot;)

This places total at *end* of group !

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

quot;Mark Jquot; gt; wrote in
message ...

I have a table like this (original cotains a row a 4000 cells)
CAR NUMBER TOTAL
Mazda 1
Mazda 7
Mazda 8
Volvo 4
Volvo 5
Skoda 5
Skoda 4
Skoda 7How do i get a sum of cells with the same name, so you get something
like this.

CAR NUMBER TOTAL
Mazda 1 16
Mazda 7
Mazda 8
Volvo 4 9
Volvo 5
Skoda 5 16
Skoda 4
Skoda 7--
Mark J
------------------------------------------------------------------------
Mark J's Profile:
www.excelforum.com/member.php...oamp;userid=30738
View this thread: www.excelforum.com/showthread...hreadid=504042