Cepp
Registered User regular

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?

Can someone tell me how to do this correctly?

0

## Posts

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"

ExpiredHeroonCeppon