Formula not working

[SD]

..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 -

 

[Don Guillett]

IF? you are trying to subtract the sum of b4;b60 from b2

=b2-sum(b4:b60)

 

[SD]

THANK YOU!!!

--
Sandy

IF? you are trying to subtract the sum of b4;b60 from b2

=b2-sum(b4:b60)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]

 

[Don Guillett]

Glad to help but you needn't shout.