Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2015, 12:09 AM
tofimoon4 tofimoon4 is offline Invoices sum Windows XP Invoices sum Office 2003
Novice
Invoices sum
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default 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.
Attached Files
File Type: xls invoices sum.xls (31.0 KB, 14 views)
Reply With Quote
  #2  
Old 12-23-2015, 10:58 AM
Kevin@Radstock Kevin@Radstock is offline Invoices sum Windows 10 Invoices sum 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
  #3  
Old 12-23-2015, 10:51 PM
tofimoon4 tofimoon4 is offline Invoices sum Windows XP Invoices sum Office 2003
Novice
Invoices sum
 
Join Date: Mar 2012
Posts: 13
tofimoon4 is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoices sum Invoices arrangement tofimoon4 Excel 9 12-06-2015 11:56 PM
Invoices sum numbering invoices michael37150 Word 12 11-01-2015 01:43 AM
Invoices sum 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
Invoices sum 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 04:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft