# group items together

on
Can an expert assist me with grouping amounts together?

This is just a smal sample but there can be 1000s of items in the spreadsheet and I do not want to use Sub Total as this will mess up other work on the spreadsheet.

So, I start with this in Columns L and M. There is other data in columns A - K.

I want to put the totals of each Account Group in Column N

Amount       Account
30.00       6101
80.00       7101
50.00       7101
20.00       9107
12.00       1101
10.00       1101
4.00       0108
4.00       0108
40.00       0108
10.00       0108
30.00       0108
6.00       0108
20.00       0108
40.00       0108
42.00       T102
85.00       T102
32.00       T102
54.00       T102
51.00       T102

So it would look like this

Amount       Account      Grp Tot
30.00       6101       30.00
80.00       7101
50.00       7101       130.00
20.00       9107       20.00
12.00       1101
10.00       1101       22.00
4.00       0108
4.00       0108
40.00       0108
10.00       0108
30.00       0108
6.00       0108
20.00       0108
40.00       0108       154.00
42.00       T102
85.00       T102
32.00       T102
54.00       T102
51.00       T102       264.00

Thanks
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try

``````=IF(B2<>B3,SUMIF(\$M\$2:\$M\$20,M2,\$L\$2:\$L\$20),"")
``````
Regards
ee20140225.xlsx

Commented:
Thanks Rgonzo1971 works great.

any chance you could look at my other post  VBA to Identify items that match

Commented:
Rgonzo1971

What I have just discovered is that the file that I need to use has some of the data as Text and some as numbers. When I change the 'Text' to 'Numbers' where the number has a leading zero it drops the 0.

Any ideas to resolve this.

Why is nothing simple?
Top Expert 2016

Commented:
Hi,

You could use a custom Format  like  0000

Regards

Commented:
does not appear to work
Top Expert 2016

Commented:
Pls try like in this example
EE20140225.xlsx

Commented:
Bizarre Rgonzo it does not work for me. Please see attached file
Copy-of-EE20140225.xlsx

Do more with