Validation Problem

C

Charles

To simplify the spreadsheet, I have Users listed across Row1 from B to G; and
Activities listed down ColumnA. Each User has to enter their time against an
Activity. The total time allowed for all Users per Activity is shown in
ColumnH.

I selected the entire Range and entered under Validation Custom Settings
this formula: =SUM($B$2:$G$2)<=$H$2 and clicked "Apply these changes to all
other cells..." and clicked "ignore bank".

The Validation works in the first row but does not work in any of the rows
below.
As usual any help in my shortcomings is greatly appreciated.
 
B

Bernie Deitrick

Charles,

You should only lock the columns:

=SUM($B2:$G2)<=$H2

HTH,
Bernie
MS Excel MVP
 

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

Data Validation Formulas 4
Sort data 2
Customise drop down list validation 3
Count max consecutive cells 2
Multiple data validation criteria? 1
Conditional Validation In Excel 1
Data Validation/Cell Protection Question 2
Can the data validation list range of one cell be driven by thecontents of another cell? 3

Top