On Jan 31, 10:08*am, 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

Try it using just the average of the 4 cells (ie =average(A1, B3, C5,
D9). I think you will find it gives you the answer 3 anyway. If the
cell is genuinely blank (blank or formula evalutes to "") it will
ignore it. Worked for me when I tested it.

Regards

Murray