=AVERAGE(IF(range,range)) array entered using CTRL+SHIFT+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"average-gal" wrote in message
...
I have a very large spreadsheet, and need to run averages for the rows and
columns.

rows list classes, columns list a score for the class given by
participant.
some participants did not attend a class, or chose not to score a class
they
attended, so they have a "null" value.

How do I average a range of 150 cells that has sporadic nulls, without the
nulls affecting the average?

Help!