how do work with validetion

  • Thread starter Thread starter shlomo
  • Start date Start date
S

shlomo

I know that its possable to do with validation that I should not be abl
to enter in column f:f that the total should be more then 10
 
Shlomo,

In the Validation dialog, choose "Custom" from the Allow list,
and use the formula
=SUM(F:F)<=100


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count how many criteria in a column match criteria in another colu 2
Calculate Age 5
need to do a look up from another sheet 1
How do I set up an IF formula with multiple qualifiers? 4
Conditional Formatting Not Working In Macro 3
Macro to add numbers in a text string 5
Sumif problem 6
IFERROR help 2

Back
Top