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
|