| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break Total (SUM question)
Dear all,
I what to sum up some value regarding different subjects, as below. Could anyone give solutions please? Original: Invoice No. Item Code Amount I0001 A3823 $100 I0001 A4144 $100 I0001 A5344 $150 I0002 R6534 $200 I0002 R7521 $60 I0003 A8641 $70 I0004 A1130 $340 I0004 R8942 $600 I0004 R2135 $70 I0004 A4556 $70 I0004 A6683 $60 I0005 R4421 $210 I0005 R4462 $100 Expected: Invoice No. Item Code Amount Total I0001 A3823 $100 $350 I0001 A4144 $100 I0001 A5344 $150 I0002 R6534 $200 $260 I0002 R7521 $60 I0003 A8641 $70 $70 I0004 A1130 $340 $1140 I0004 R8942 $600 I0004 R2135 $70 I0004 A4556 $70 I0004 A6683 $60 I0005 R4421 $210 $310 I0005 R4462 $100 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| page break with auto sub total | Excel Worksheet Functions | |||
| Calculate time with a break and total hours | Excel Worksheet Functions | |||
| How do I insert a Sub total at every page break? | Excel Discussion (Misc queries) | |||
| want a formula give total quanitity break up frm other sheet | Excel Worksheet Functions | |||
| How to subtract a lunch break from total hrs worked in timesheet | Excel Programming | |||
Threaded Mode
