Subtraction using answer of sum within same formula

[brian_2me]

Hi All,

Firstly apologies for title, hard to phrase my requirements without using an example,
Basically i'm looking for a formula to calculate A1-A2, answer - A3, answer - A4 and so on
A1 = 10
A2 = 1
A3 = 2
A4 = 1
therefore formula should 10-1=9-2=7-1=6

Hope the above makes sense

[slx]

Please Login or Register  to view this content.

[MrShorty]

I am not sure I understand your need. Something slx proposes should give you the final result. If you are looking for the intermediate results, you could use a similar formula with an appropriate combination of relative and absolute references:

B2 -- =$A$1-sum($A$2:A2) 'note the absolute and relative references.
B3 -- copy of B2
B4 -- copy of B2

[brian_2me]

Thanks but forgot to state even though my example is a range, my formula would need to be modified for specific cells, the formula provided by MrShorty is working only i need to combine formula of B2 + B3 + B4 together as one formula.

Thanks

[brian_2me]

I am not sure I understand your need. Something slx proposes should give you the final result. If you are looking for the intermediate results, you could use a similar formula with an appropriate combination of relative and absolute references:

B2 -- =$A$1-sum($A$2:A2) 'note the absolute and relative references.
B3 -- copy of B2
B4 -- copy of B2

How do i combine formula of B2 + B3 + B4 together as one formula

[brian_2me]

How do i combine formula of B2 + B3 + B4 together as one formula

Figured it out, thanks everyone