Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula not working
..I am just turing to Take a Total (B2) and subtract b4:60 and I get a value
error message. My formula looks like this =Sum B2 - B4:B60 What I I doing wrong!!! Thanks - -- Sandy |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula not working
IF? you are trying to subtract the sum of b4;b60 from b2
=b2-sum(b4:b60) -- Don Guillett Microsoft MVP Excel SalesAid Software "SD" wrote in message ... .I am just turing to Take a Total (B2) and subtract b4:60 and I get a value error message. My formula looks like this =Sum B2 - B4:B60 What I I doing wrong!!! Thanks - -- Sandy |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula not working
THANK YOU!!!
-- Sandy "Don Guillett" wrote: IF? you are trying to subtract the sum of b4;b60 from b2 =b2-sum(b4:b60) -- Don Guillett Microsoft MVP Excel SalesAid Software "SD" wrote in message ... .I am just turing to Take a Total (B2) and subtract b4:60 and I get a value error message. My formula looks like this =Sum B2 - B4:B60 What I I doing wrong!!! Thanks - -- Sandy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Not working | Excel Discussion (Misc queries) | |||
Formula not working | Excel Worksheet Functions | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
IF OR formula not working | Excel Discussion (Misc queries) | |||
formula not working | Excel Discussion (Misc queries) |