Thread: [Solved] Invoices sum
View Single Post
 
Old 12-23-2015, 10:58 AM
Kevin@Radstock Kevin@Radstock is offline Windows 10 Office 2016
Office 365
  
Join Date: Feb 2012
Posts: 94
Kevin@Radstock is on a distinguished road
Default
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
File Type: xls 007-invoices sum.xls (69.0 KB, 25 views)
Reply With Quote