ExcelBanter - Formula Not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Not working (https://www.excelbanter.com/excel-discussion-misc-queries/188178-formula-not-working.html)

Formula Not working

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

Mike H

Formula Not working

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

All times are GMT +1. The time now is 08:38 AM.