How do you assess pass or fail for each?
If you do it by number:

=IF(COUNTIF(A1:A5,"74")=5,SUM(A1:A5),0)

requires each number in A1:A5 be greater than 74 or it returns 0.

If you use the word 'pass' somewhe

=IF(COUNTIF(B1:B5,"pass")=5,SUM(A1:A5),0)

Where B1:B5 contains 'pass' for a pass and anything else for "still
developing" - you can't fail anyone these days!


--
Steve

"jhumphreys" wrote in message
...

Hi there
I need to use a sum function that only happens if a certain condition
exist, this condition being that every number in a column has to be over
a certain level, here is the scenario:

Students have to take a series of 5 parts of an examination tests, each
part is assessed and a score awarded, the scores for all 5 are summed
and an overall mark awarded for their performance. The condition is
though that they HAVE to have acheived a pass in each test, If they fail
in at least one text, it doesn't sum or just returns a zero result.

Anyone suggest how to do this?

Thanks
JH


--
jhumphreys
------------------------------------------------------------------------
jhumphreys's Profile:
http://www.thecodecage.com/forumz/member.php?userid=470
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=112852