=Sum

[MGumbrell]

I have the following formula that was created using the auto sum, so I don't understand why I am receiving an error message.

Cell (B2) contains a postive value
Range (B3:B7) contains positive values

Cell (B8) needs to subtract the value of Range (B3:B7) from Cell (B2)

The auto sum helps create the following formula:-
=Sum(B2-B3:B7)

I have also tried
=Sum(B2)-(B3:B7)

This creates a #VALUE error

Can anyone advise me on a solution to what would seem to be a very easy formula.

Thanks, Matt

 

[chergh]

Think you need more coffee

=B2-sum(B3:B7)

 

[MGumbrell]

Thank you

Some answers can make you feel a right plum.

Regards, Matt

 

[chergh]

Happens to us all