how do work with validetion

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
 
C

Chip Pearson

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
 
Top