Thank you
One more question - In reference to this formula, how would I also omit a
blank cell? It's a chronological spread, so if I am at the beginning of the
report cycle, there will be areas not yet scored. I'd like my average to be
"to date". I hope that makes sense.
Your input is really helpful - thank you!
If the only error values would be #N/A..
try this regular formula:
=SUMIF(A1:A10,"<#N/A")/COUNT(A1:A10)
Adjust range references to suit your situation.
Is that something you can work with?
Regards,
Ron Coderre
Microsoft MVP (Excel)
"LilBeanie1033" wrote in message
...
I am attempting to build a running daily score average report based on
several categories that either have a numeric or N/A value. How do I omit
the N/A values from the average? I can't seem to make it stop assigning a
zero value to those cells.
|