Invoices sum

		Microsoft Office Forums > Microsoft Excel > Excel
Invoices sum

12-23-2015, 10:58 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 10 Invoices sum

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

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.

Attached Files

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:57 AM.