View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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