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 |
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 |
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 |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com