Try this...
Select the range D10:D14
Goto Data>Data Validation
Allow: Custom
Formula:
=AND(COUNT(D10),D10>=0,SUM(D$10:D$14)<=8)
Try this...
Select the range D10:D14
Goto Data>Data Validation
Allow: Custom
Formula:
=AND(COUNT(D10),D10>=0,SUM(D$10:D$14)<=8)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks