#1
|
|||
|
|||
Invoices sum
Dear sir,with best regards,asking you kindly to help by code or formula to sum the costs of each invoice mentioned in attached file.
Many thanks in advance. |
#2
|
|||
|
|||
Hi
See the attached file, it is important that you put a dash in the cell where the data has finished. Then in H6 and copy down the formula below. Code:
=IF(B6<>"",SUM(G6:OFFSET(G6,MATCH(TRUE,INDEX(B7:B$26<>"",0),0)-1,,)),"") |
#3
|
|||
|
|||
Dear sir,many thanks for this very nice and saver formula .
My regards . |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Invoices arrangement | tofimoon4 | Excel | 9 | 12-06-2015 11:56 PM |
numbering invoices | michael37150 | Word | 12 | 11-01-2015 01:43 AM |
Creating Invoices using data from a spreadsheet | tjcusick | Excel Programming | 3 | 12-05-2013 08:36 AM |
Help making invoices easier | wbowles | Office | 0 | 07-17-2013 10:39 AM |
Creating Invoices from CSV | iansan5653 | Excel | 5 | 02-07-2012 05:05 PM |