ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to make a validation that makes one box equalsum of other boxe (https://www.excelbanter.com/excel-discussion-misc-queries/192527-how-make-validation-makes-one-box-equalsum-other-boxe.html)

Holly

how to make a validation that makes one box equalsum of other boxe
 
how to make a validation that makes one box equalsum of other boxes?

I used "custom" and the formula like =A1=SUM(B1,C1,D1), but it doesn't work.
Please help. Thanks.


Bob Phillips

how to make a validation that makes one box equalsum of other boxe
 
Is A1 the DV cell?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Holly" wrote in message
...
how to make a validation that makes one box equalsum of other boxes?

I used "custom" and the formula like =A1=SUM(B1,C1,D1), but it doesn't
work.
Please help. Thanks.





All times are GMT +1. The time now is 12:50 PM.

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