Help! Formula for AVG when group size varies

J

John

I've set up an average formula for 7 raters

AVERAGE(B2:B8)

However just discovered some of the raters will be absent
for some candidates. What's the formula that will
average only those ratings reported? In other words a
formula that won't count an empty cell.

Thanks in advance for your help!

John
 

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

Top