arithmetic formula in range

[ghadir14]

Hello
I'm trying to take a figure in eg column A1, subtract it from column E1, and then subtract any cells in columns B,C,D on same row...
then have this formula copied right the sheet.
using right click- paste special-formula...(which isn't working)
the formula i'm trying is eg as follows..
A1- E1-(B1:D1)

i've tried this by also inserting the word range before B1 but it doesn't work...any tips....?

[corinereyes]

Hi ghadir14,

Not sure if this is what you want. Try:

=A1-E1-B1-C1-D1

[ghadir14]

Thanks ,but to me this is obvious, I thought there may a quicker way instead of typing/listing each cell reference....hence I tried range, or B1:d1

[corinereyes]

Hi ghadir14

If you dont have any negative answers this formula would work.

=ABS(SUM(BCDE)-A1)

Name the range B1:E1 to BCDE.

Im sure there is a better way to do this.

[daddylonglegs]

Try

=A1- E1-sum(B1:D1)