Thread: #DIV/0!
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.newusers
Jim S[_2_] Jim S[_2_] is offline
external usenet poster
 
Posts: 6
Default #DIV/0!

Wow what a response, thanks. Let me take the first reference in the formula
and explain, ESP1!F24 is a cell that also has a formula in its own cell that
asks for an average of 4 other cells C24, D24, and E24 on the same
worksheet, one of those cells has data inserted and the others dont but I
still get the #DIV/0! and I wanted this formula to reflect the existing data
from C even though the other cells are still without data, thats the reason
for using the average formula. I had put the /9 because it wasnt giving me
an average but a sum total even though it said average.

--
Jim Salyer
Area Supervisor
Home 505-474-4863
Mobile 505-670-4138
Fax 505-474-4540
"joeu2004" wrote in message
ups.com...
Errata....

On Mar 8, 6:12 pm, "joeu2004" wrote:
First of all, you probably want:
AVERAGE(ESP1!F24,ESP2!F24,LV!F24,LA!F24,RAT!F24,SF 1!F24,SF2!F24,SF3!
F24,TAO*S!F24)
[....]
AVERAGE() probably returned #DIV/0! because AVERAGE() thinks that all
the cells are blank or contain non-numeric values (e.g. text).


Oops, my bad! I was thinking of __my__ form of AVERAGE().
AVERAGE(A1+...+A9) works just fine if all cells in the range are blank
(or zero). There is no problem with AVERAGE() if all the arguments
sum to zero. If any cell is non-numeric, the expression will returns
#VALUE!, and so does AVERAGE().