• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 112
  • Last Modified:

group items together

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
0
Jagwarman
Asked:
Jagwarman
  • 4
  • 3
1 Solution
 
Rgonzo1971Commented:
Hi,

pls try

=IF(B2<>B3,SUMIF($M$2:$M$20,M2,$L$2:$L$20),"")

Open in new window

Regards
ee20140225.xlsx
0
 
JagwarmanAuthor Commented:
Thanks Rgonzo1971 works great.

any chance you could look at my other post  VBA to Identify items that match
0
 
JagwarmanAuthor 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?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rgonzo1971Commented:
Hi,

You could use a custom Format  like  0000

Regards
0
 
JagwarmanAuthor Commented:
does not appear to work
0
 
Rgonzo1971Commented:
Pls try like in this example
EE20140225.xlsx
0
 
JagwarmanAuthor Commented:
Bizarre Rgonzo it does not work for me. Please see attached file
Copy-of-EE20140225.xlsx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now