Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for adding up totals of groups
Hi Could somebody please help me with the following problem? I have a whole heap of raw data that looks like this Client Product Group Qty $ aaa 1 1 66.39 aaa 1 1 103.78 aaa 1 1 78.8 aaa 1 1 96.96 aaa 2 1 54.17 aaa 2 1 29.74 aaa 2 1 28.66 aaa 2 1 30.53 aaa 2 1 41.49 aaa 2 1 28.78 aaa 3 1 57.1 aaa 4 1 25.42 aaa 4 2 14.86 aaa 4 1 14.99 aaa 4 2 5.99 aaa 4 1 41.6 bbb 1 -1 -130 bbb 1 1 81.1 bbb 1 1 124.48 bbb 1 1 97.82 bbb 2 1 70.99 bbb 2 1 22.18 bbb 2 1 22.66 bbb 2 1 36.09 bbb 2 1 27.62 bbb 2 1 70.99 bbb 2 1 70.99 bbb 2 1 27.62 bbb 2 1 21.5 bbb 3 1 90 bbb 3 1 72 bbb 4 1 27.6 bbb 4 1 35.88 bbb 4 10 148.32 ccc 1 1 87.9 ccc 1 1 79.17 ccc 1 1 100.08 ccc 1 1 80 ccc 1 1 451.05 ccc 1 1 350 ccc 2 7 55 ccc 4 1 12.02 ccc 4 1 8.15 ccc 4 1 41.6 ccc 4 1 11.15 ccc 4 1 14.83 ccc 5 0 0 ccc 5 2 771.62 ccc 48 1 166.6 ccc 48 1 224 I would like to create a formula that adds up the total quantity of client aaa’s sales and in another cell adds up aaa’s the total sales for each product group. Then I would like to another cell that adds up the total quantity for and total sales for aaa’s product groups 3 & 4. Then I would obviously do this for each client Please help Thanks Andrew -- koba ------------------------------------------------------------------------ koba's Profile: http://www.excelforum.com/member.php...o&userid=28639 View this thread: http://www.excelforum.com/showthread...hreadid=487508 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My formula doesn't update totals when I change numbers. | Excel Discussion (Misc queries) | |||
Hide formula | Excel Worksheet Functions | |||
Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions |