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)
New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Subtracting a range total from another
1 post
• Page 1 of 1
Subtracting a range total from another
by FrancisM » Fri Nov 01, 2013 9:15 am
- FrancisM
- Regular
- Posts: 44
- Joined: Jan 30, 2013
- Reputation: 0
- Excel Version: 2010
1 post
• Page 1 of 1
Return to Excel Tips and Tutorials
Who is online
Users browsing this forum: No registered users and 1 guest