Try

=B2-SUM(B3:B100)

Mike

"SD" wrote:

Hello - I need help! I am trying to add my Total units (B2) and subtract
orders B3:B100. My formula is =Sum B2-B3:100. When I try to do this I
receive a #value! error message.

Please help!
--
Sandy