View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default average if (different cells) with formulas

hi
=sum(A1+B3+C5+D9)/Count(A1,B3,C5.D9)

Regards
FSt1

" wrote:

Hi there,

I was wondering if there a simple way to average approx. 5 different
cells (not a range) in these different cells there are formulas I
don't want to average them if they are "" or 0.

ex. A1 = 1 B3 = "" C5=4 D9=4 AVERAGE SHOULD BE 3
AVERAGE(A1,B3,C5,D9;<"") something like this.

IS this possible.

Thanks.
CD