jhumphreys;404767 Wrote:
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
JHHi and welcome to the code cage!, supplying a workbook would be much
better as we can help you directly with your particular structure,
however, attached is a sample of how to use sumproduct, take a look at
it and post back any questions or queries :)
+-------------------------------------------------------------------+
|Filename: Sumproduct example.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=172|
+-------------------------------------------------------------------+
--
Simon Lloyd
Regards,
Simon Lloyd
'The Code Cage' (
http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=112852