Simple Excel Problem

Cepp

Im trying and failing to get this working. I want to add a bunch of numbers together and then subtract the total from a larger number. I tried =SUM(B6-(B7:B10)) but this just gives me a #VALUE! error.

Can someone tell me how to do this correctly?

ExpiredHero

You have SUM in the wrong place

I think what you are looking for is =(B6-SUM(B7:B10))


If you look at it in pseudo code you wwant to be saying "this cell equals B6 minus the sum of cells B7 through B10". With your original formula (with SUM at the beginning) you are saying "take the sum of B6 minus the first value in this range of cells"

Cepp

Brilliant, cheers mate, that's exactly it. I've basically forgotten everything about using Excel since using it briefly 10 years ago so thanks for the explanation.