View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default skip errors in an average

This will work commited as an array formula (CTRL+SHIFT+ENTER)

=AVERAGE(IF(ISERROR(M3:M58),"",M3:M58))

--
Regards,
Dave


"tamiluchi" wrote:

I'm trying to get an average of a series of averages. Some of the cells in
the series have a 0/div error, which is ok for the series. I can't get the
average of the averages formula to ignore the error cells. Here's what I'm
trying:
=AVERAGEif(M3:M58,"<0").
Can anyone point out the simple solution that I'm overlooking?
Thanks!
Tammie