View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Simon Lloyd[_293_] Simon Lloyd[_293_] is offline
external usenet poster
 
Posts: 1
Default Creating a pass of fail condition


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