Glad to help but you needn't shout.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"SD" wrote in message
...
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