ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Formula not working (https://www.excelbanter.com/new-users-excel/188182-formula-not-working.html)

SD

Formula not working
 
..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

Don Guillett

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



SD

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




Don Guillett

Formula not working
 

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






All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com