Thread
:
Formula not working
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett