Repeat Values in Column A, Break and Sum
 

I have data in Column A that repeats in groups; AAA, BBB, CCC, etc. Each of
these column A values is associated with a varible in column B. I want to
break at the end of a group and sum the column B.



Here's what I have and what I need.


What I have:


AAA 111
AAA 222
AAA 111
BBB 444
BBB 222
BBB 111
BBB 111
CCC 444
DDD 222
DDD 666


Here's what I want -- the break and the summation of Column B

AAA 111
AAA 222
AAA 111
444 (Sum of AAA)

BBB 444
BBB 222
BBB 111
BBB 111
888 (Sum of BBB)

CCC 444
444 (Sum of CCC)

DDD 222
DDD 666
888 (Sum of DDD)



I appreciate anything you can do to help.

Repeat Values in Column A, Break and Sum
 

Highlight the data, go to

Date--Subtotals

Follow the instructions

"ConfusedNHouston" wrote:

I have data in Column A that repeats in groups; AAA, BBB, CCC, etc. Each of
these column A values is associated with a varible in column B. I want to
break at the end of a group and sum the column B.



Here's what I have and what I need.


What I have:


AAA 111
AAA 222
AAA 111
BBB 444
BBB 222
BBB 111
BBB 111
CCC 444
DDD 222
DDD 666


Here's what I want -- the break and the summation of Column B

AAA 111
AAA 222
AAA 111
444 (Sum of AAA)

BBB 444
BBB 222
BBB 111
BBB 111
888 (Sum of BBB)

CCC 444
444 (Sum of CCC)

DDD 222
DDD 666
888 (Sum of DDD)



I appreciate anything you can do to help.

Repeat Values in Column A, Break and Sum
 

How about if you just display the total of each group in Column C, next to
the last group entry?

With datalist starting in A1, try this in C1:

=IF(A1<A2,SUMIF($A$1:A1,A1,$B$1:B1),"")

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ConfusedNHouston" wrote in
message ...
I have data in Column A that repeats in groups; AAA, BBB, CCC, etc. Each
of
these column A values is associated with a varible in column B. I want to
break at the end of a group and sum the column B.



Here's what I have and what I need.


What I have:


AAA 111
AAA 222
AAA 111
BBB 444
BBB 222
BBB 111
BBB 111
CCC 444
DDD 222
DDD 666


Here's what I want -- the break and the summation of Column B

AAA 111
AAA 222
AAA 111
444 (Sum of AAA)

BBB 444
BBB 222
BBB 111
BBB 111
888 (Sum of BBB)

CCC 444
444 (Sum of CCC)

DDD 222
DDD 666
888 (Sum of DDD)



I appreciate anything you can do to help.