| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing inv in list
I have a list of different invoices with supplier
reference numbers in the next column. What i want to do is sum the total for each supplier and either copy this to a new sheet or delete the multiple invoice lines and just keep the sum of the invoices, is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing inv in list
Excell has an option that will do that without VBA.
Go to: Data -- Subtotal where you choose what you need.... Good luck -----Original Message----- I have a list of different invoices with supplier reference numbers in the next column. What i want to do is sum the total for each supplier and either copy this to a new sheet or delete the multiple invoice lines and just keep the sum of the invoices, is this possible? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summing data from a list | Excel Discussion (Misc queries) | |||
| SUMMING UP ONLY ONES IN A LIST | Excel Discussion (Misc queries) | |||
| Summing List entries | Excel Discussion (Misc queries) | |||
| Summing List Entries 2 | Excel Discussion (Misc queries) | |||
| Summing last row in list | Excel Programming | |||
Linear Mode
