| 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) | |||
Linear Mode
