Average of only cells containing numeral value
Thank you, I appreciate your help.
Kind Regards
Tanya
"Ragdyer" wrote:
One way:
=IF(COUNT(B1:B10)0,AVERAGE(B1:B10),"")
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tanya" wrote in message
...
Hi Ron,
I'm sorry, I didn't make myself clear, you are quite right, if there are
values to average, the AVERAGE function will ignore text, however my table
has no values until I update the table, in the mean time I get #DIV/0!
Is there a way to avoid this error message?
It probably sounds like a ludicrous situation, but I am working with class
results for a school year and until the task has been completed by the
class
and results recorded there are no values to average.
Kind Regards
Tanya
"Ron Coderre" wrote:
The AVERAGE function ignores text
Per Excel Help for the AVERAGE function:
If an array or reference argument contains text, logical values, or
empty cells, those values are ignored; however, cells with the value zero
are included.<<
Are you experiencing something different?
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Tanya" wrote:
Hi
Can anyone advise me please of a formula to calculate the average for
a
range where only numerals are present. i.e. I have a column with a
number of
text values in which the numeral value has no entry?
Thank you in advance.
Regards
Tanya
|