Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 94
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make Validation List Wider - Excel 2003 cmarion Excel Discussion (Misc queries) 4 June 18th 08 09:08 PM
Check boxe size Melissa Excel Discussion (Misc queries) 1 October 3rd 07 04:38 PM
How do I make a Validation List in Excel, using data on a second Driver Excel Discussion (Misc queries) 2 February 23rd 06 01:30 PM
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO CHAIM Excel Discussion (Misc queries) 1 September 29th 05 08:28 PM
Make Data validation List Alphabetical?? Slumbering Gorilla Excel Worksheet Functions 6 November 19th 04 09:49 PM


All times are GMT +1. The time now is 04:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"