View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
Posts: 109
Default Average of different cells ignoring blanks

Hi

I am struggling to get averages of multiple cells on a sheet (not in a
range) whilst ignoring blank cells.

Over what is the struggle?

AVERAGE() ignores blank cells automgically so that part's easy-peasy; if
the cell locations aren't contiguous, you just have to enumerate them in
the argument list.

--