Excel Help Needed :-/ — OZONE Asylum, home of the Mad Scientists

This page's ID: 29402

Edit Post

Who can edit a post?	The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	hey inmates, i need some help here. i'm not sure if this is even possible with excel, but i thought i should ask. i got a table like this [code] customer text fee 23458 blabla 10 euros 23458 blabla 30 euros 12521 blabla 5 euros 12521 blabla 6 euros 12521 blabla 17 euros 13542 blabla 8 euros [/code] now what i want is to make a sum of all fees from each customer. so for customer 23458 this would be 40 euros. and so on. i cant do this by hand because the table has about 30.000 entries. of course something like this should be done in access, but thats not my fault - i got this table from my chief. however, i have the option (if there is no other way round) to export the whole table to access, but how do you write a query which sums all the fees from every customer without telling the computer WHICH customer it has to select everytime? i want the program to automatically find table rows with the same customer ids AND to summarize it's fees. any help or tips would be very much appreciated! thanks in advance! [url=http://www.thespacebetweenus.com]The Space Between Us[/url] \| [url=http://lukas.grumet.at]My Blog: lukas.grumet.at[/url] Loading...
Options:	Enable Slimies Enable Linkwords

Edit Post