View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
SD SD is offline
external usenet poster
 
Posts: 24
Default 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