Ok, so I found what I did wrong. Stupid error! I had copied the formula
down to the associated cells in their respective rows but I failed to do the
B$2:F$2. My error, my bad! I had B2:F2 etc. ;-(

Where can I found additional info on the CSE features? I guess I didn't
even know they existed!

Is there an easy way to determine which day of the week the students do
their best? That is, can I average the Monday, Tuesday, Wednesday, Thursday
and Friday results and see which day is best? I know how to determine if a
day is on Monday through Friday but keep in mind that not all days have
quizes and some weeks are only four (4) days - like Memorial Day week or
Easter/Good Friday Week or Christmas/New Years Day week or Thanksgiving Day
week (no Thursday or Friday classes and sometimes not even a Wednesday).
Hence, I'd need to check for the day of the week before I do anything.

So, how can I determine from a set of quizes (M-F) what the average was for
Monday vs Friday? I'd like to also be able to sum the total # right for,
say, Friday.
Thanks!


"Ragdyer" wrote:

Using Mike's array formula:
=AVERAGE(IF(B$2:F$2="y",B4:F4))
And copying down *after* the CSE, I *can't* duplicate your results.

I just get a simple 0 return, no error message!

What *exact* formula are you using?
What, if anything, is in the cells (B4:F4, B5:F5, etc...) before the test
scores are entered?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tom" wrote in message
...
Mike
GREAT answer! It worked! There are some students who have not taken a
test
yet and hence I get a "#div/0" response for these students. How do I
correct
this, too? WHERE did you find/know how to do this!?? Never even seen it!
TIA!!


"Mike H" wrote:

Tom,

Try this array formula

=AVERAGE(IF(B2:H2="y",B3:H3))

This is an array formula which must be entered with CTRL+Shift+Enter and
NOT
'just enter. If you do it correctly then Excel will put curly brackets
around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array


Mike

"Tom" wrote:

Excel 2003 SP3
WinXP Pro SP3

I have a set of tests that I need to average for some students.
In row 7 for columns D through 12 I indicate a Y or an N if I'd like
to
include that weeks test/quiz into the final test score. Sometimes I
provide
pre-tests and pre-quizes just to determine the level of understanding
of the
material. I need to keep these results but I don't want to include
them in
the final outcome. Hence, the student's results may be like this:
Column
A B C D E F
Week # 1 2 3 4 5
Student Name
Include? N N Y N Y
Results for 72 64 84 53 89 Average should be (84+89)/2
(2
test w/ Y)
Doe, John
Results for
Smith, Mary 75 79 85 67 79 Average should be (85+79)/2
(2
tests w/ Y)
How can I conditionally SUM and average the above data by including
ONLY
those results with a Y in the "Include?" cell of the same column that
has the
appropriate results? (I don't want a deep IF-conditional test if at
all
possible)
TIA!