| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate total $ based on rows displayed by sort
Hello.
I'm using Excel 2003. I have data in the following format: Product Quantity Price Extended Price product a n $xxx.xx $xxx.xx product b n $xxx.xx $xxx.xx product c n $xxx.xx $xxx.xx .. .. Subtotal $xxx.xx Total $xxx.xx I would like to calculate the subtotal and total amounts based on the rows displayed from a sort (i.e. sort by product name). What calculation/formula would be used in the subtotal and total cells? TIA for the help, DavidP |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate total $ based on rows displayed by sort
Data | Subtotals... | Subtotal on Product change
Regards Trevor "DavidP" wrote in message ... Hello. I'm using Excel 2003. I have data in the following format: Product Quantity Price Extended Price product a n $xxx.xx $xxx.xx product b n $xxx.xx $xxx.xx product c n $xxx.xx $xxx.xx . . Subtotal $xxx.xx Total $xxx.xx I would like to calculate the subtotal and total amounts based on the rows displayed from a sort (i.e. sort by product name). What calculation/formula would be used in the subtotal and total cells? TIA for the help, DavidP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| How to sort two groups of rows while skipping over a row | New Users to Excel | |||
| Sorting Rows | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
Linear Mode
