New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

Subtracting a range total from another

Free Excel Tips and Tutorials
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

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 1 guest

cron