So I read this as saying, if the cells specified
are numerals, add them; else return a blank?

Yes

--
Biff
Microsoft Excel MVP


"GB3 via OfficeKB.com" <u57077@uwe wrote in message
news:a2066a2acc939@uwe...
Thanks again, T. Clever. So I read this as saying, if the cells
specified
are numerals, add them; else return a blank? I would never have thought
to
use a COUNT function in this context.

T. Valko wrote:
How about if you change your Total formula to something like this:

=IF(COUNT(B2:F2),SUM(B2:F2),"")

That way, instead of returning 0 the formula will return a blank until
scores are entered. Then, you can go back to using the AVERAGEIF function:

=AVERAGEIF(A$2:A$11,I2,G$2:G$11)

Where I2 = Group 1, G$2:G$11 = Total score

Thanks, T. That worked. I appreciate the explanation too.
How about this little complication.
[quoted text clipped - 54 lines]
Group 1 1 3 2
Group 2 0 0 0

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201001/1