Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula only working sometimes | Excel Discussion (Misc queries) | |||
Formula not working | Excel Worksheet Functions | |||
formula is not working | Excel Worksheet Functions | |||
Why isn't this formula working? | Excel Discussion (Misc queries) | |||
Formula not working | Excel Worksheet Functions |