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!