New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Subtracting a range total from another

Free Excel Tips and Tutorials

Subtracting a range total from another

Postby FrancisM » Fri Nov 01, 2013 9:15 am

Below is a formula that enables you to both add & subtract the value of ranges of cells, in one formula.

=SUM(E106:E115) - SUM(I106:I115)
FrancisM
Regular
 
Posts: 44
Joined: Jan 30, 2013
Reputation: 0
Excel Version: 2010

Return to Excel Tips and Tutorials

Who is online

Users browsing this forum: No registered users and 4 guests