average cells omitting nulls

A

average-gal

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating an average of data between two dates 1
A formula to auto-update a classification ONLY if it goes UP 3
Changing cell color with a formula? 4
zero value cells/blank cells causing error in AVERAGE? 5
Spurious Formula Omits Adjacent Cells 2
Average without Hidden Cells 4
Trying to average the contents of a cell across multiple worksheet 12
Here's a challenge... 4

Top