Try something like:

=IF(COUNTA(A1:F1)<6,"Data missing",SUM(A1:F1))

You say A1 to F1 but your SUM example is AE to AH which is only 4 entries
(confused!)

"confused teacher" wrote:

I have a formula that will generate a grade based on data entered by the
user. my problem being that the grade will still generate even if the
operator fails to put all the data in, this could lead to an error in the
students grade.

I need to ensure that the grade will not calculate and display unless all
the results are entered.
One of the formulas used to assign a grade is:

=IF('DO NOT DELETE'!Z384.99,"HD",IF('DO NOT DELETE'!Z374.99,"D",IF('DO NOT
DELETE'!Z364.99,"C",IF('DO NOT DELETE'!Z349.99,"P",IF('DO NOT
DELETE'!Z342.99,"PC",IF('DO NOT DELETE'!Z3=0.1%,"F"))))))

The result in Z3 will be a SUM of the grades in worksheet "Assessment 2 30%
60% 10% and could be a sum of 6 cells from A1 to F1.

My question then is how do I tell Excel to not add the figures unless all 6
cells contain an entry? I assume that I need to put the instruction in front
of the formula used in cell Z3 as above.

The fomula in cell Z3 is:
=SUM('Assessment 2 - 30%, 60% & 10%'!AE8:AH8)*1.666667

If someone has a solution ad can fix the formula for me it would be
appreciated.

Thanks

Brian