Hi Brian,

Pleased that I have helped so far and will try to help with you new question.

I see that you only want to sum it if it is greater than zero. However, what
do you want to do if the sum is less than 70. Like if it adds up to 68 do you
want to insert 70 instead?

I am going to bed now so will look at your reply in the morning.

Regards,

OssieMac

"Brian" wrote:

one more thing off this subject. I've got calculations adding up different
cells on the page giving a final grade. But I need the grade to be no lower
than 70.
here is my cell formula.
=IF(SUM(F19,Q19,F38,Q38,(F49:J49))0,SUM(F19,Q19,F 38,Q38,(F49:J49)),(""))

"OssieMac" wrote:

Hi Brian,

Try Data Validation.

Select F13:J13

xl2007 version: Data tab on ribbon-Data tools block-Data Validation

pre xl2007 versions: Menu item Data-Validation-

In allow field: Select Custom

Uncheck Ignore blanks

In Formula field: =COUNTA($F$13:$J$13)<2

This validation does not confirm that an X has been entered but it only
allows one of the cells to have an entry.
Regards,

OssieMac


"Brian" wrote:

I am making a spread sheet to be used for data entry. the data entered is an
"x" with in a column. But I only want to allow one cell from f13:j13 to be
entered
Ex f13 is unsat g13 in below ave h13 is average and so on so by puting an
"x" in f13 it totals down and I don't want a double entry within the range of
f13:j13