Imagine a simple chart, where B4 = 6 and C4 = 7
B5 = 15 and C5 = 10
B6 = 4 and C6 = 8
I require cell D4 to be B4-C4
cell D5 to be B5 -C5
cell D6 to be B6-C6
From the above data you would get -1, +5, and -4 respectively.
However, I require to add the resulting figures of D4 to D6 ignoring the minus and plus figures eg. D7 to be 10 and not zero.
What would the formula for D7 be?
Please help
Bookmarks