Sounds like it, but I cannot see what off-hand. Can you post the workbook
somewhere, such as http://cjoint.com

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Glint" wrote in message
...
Thanx Bob, I just found that the cells at the side and bottom of my range
that I want to use to sum the totals in the rows and columns are affecting
data entry. When I placed the formulas for these cells "=SUM(B2:Z2)" etc,
I
found I could no longer update my range. Surely, I am doing something
wrong.
--
Glint


"Bob Phillips" wrote:

That's very odd, that is not how I did it. I created the test data, then
the
formula, no problem.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Glint" wrote in message
...
Bob, what I found was that no figures were accepted if there was data
in
any
cell in the range BEFORE I added the formula. When I tried the formula
in
another area of the worksheet that had no data whatsoever, the formula
worked
fine. But if any cell in the range had data, the range locked up, not
allowing editing or addition of data.
--
Glint


"Bob Phillips" wrote:

What do you mean that it only works in a blank worksheet? There is
no
point
if the workbook is blank.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Glint" wrote in message
...
Thanx Ken. I did not realize at first that the formula only works
in a
blank
worksheet. I had problems with one that had data.
--
Glint


"Ken Johnson" wrote:

Hi Glint,
Looks like you've changed from 400 to 225, so the formula should
be...

=AND(B2=1,B2<=225,COUNTIF($B$2:Z26,B2)=1)

If so, try these steps to get it in place and working...

1. Select B2:Z26
2. Go Data|Validation...
3. On the Settings Tab of the Data Validation dialog, click in
the
Allow: box and select Custom.
4. Type the above formula into the Formula: box
5. If you want a message to appear when a cell in the range is
selected
add it to the Input Message Tab of the Data Validation dialog
6. If you want a warning Error Alert message displayed when the
user
tries to enter an invalid value then add it to the Error Alert
tab
of
the Data Validation dialog.
7. Click OK.

Ken Johnson