Invoices sum

tofimoon4 · #1 12-23-2015, 12:09 AM

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.

Kevin@Radstock · #2 12-23-2015, 10:58 AM

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,,)),"")

See attached file.

tofimoon4 · #3 12-23-2015, 10:51 PM

Dear sir,many thanks for this very nice and saver formula .
My regards .

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