I am trying to subtract a total of a column from the number in another column. I am entering =sum(B1-(c2:c20)) I get an error code of #value. What am I doing wrong?

Hi
I tried this and it looks like it works

=B1-SUM(C2:C20)

Regards

thank you! I knew it was simple!

Glad it worked:-)

I wonder how you knew that, not knowing the answer....

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post