=IF(COUNTBLANK(A1:A5)0,0,SUM(A1:A5))
Regards,
Stefi

€žjhumphreys€� ezt Ã*rta:


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