Copy across F2

Copy across to F2 then down to row 36.

Biff

"Biff" wrote in message
...
Hi!

On the Ranking sheet, cell C2, modify this portion of the formula:

SUM(IF('Math CST'!E2'Math CST'!E$2:E$36

Change to:

SUM(IF(('Math CST'!E2'Math CST'!E$2:E$36)*('Math CST'!E$2:E$36<"")

Make sure you re-enter as an array!

Copy across F2

Biff

"daddioja" wrote in
message ...

Another user helped me with some of the functions in this file, and the
problem is that I have one bug I can't fix. There are four sheets. The
first two sheets contain different types of scores.
The fourth sheet ranks each of the different types of scores on both
first sheets. The third sheet reports out on the bottom five scores in
each category. If one of the scores is missing, the whole thing gets
screwed up.

I have attached the file and removed a some of the scores to
illustrate. If anyone is willing to take a look and recommend a fix, I
would be so appreciative.


+-------------------------------------------------------------------+
|Filename: RSDSS v7.xls.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4900 |
+-------------------------------------------------------------------+

--
daddioja
------------------------------------------------------------------------
daddioja's Profile:
http://www.excelforum.com/member.php...o&userid=35024
View this thread:
http://www.excelforum.com/showthread...hreadid=552887