Averaging Cells

[inkblot]

I have Excel 2002 and Pocket Excel 2002.
When I average a non contiguous series of cells, the desktop version does not count blank cells (good) and the pocket excel counts blank cells as zero (bad).
Is there another formula I can use to average these cells so that it will not count blank cells on Pocket Excel

=AVERAGE(H4,L4,P4,T4,X4,AB4)

 

[Aladin Akyurek]

On 2002-05-10 12:46, inkblot wrote:
I have Excel 2002 and Pocket Excel 2002.
When I average a non contiguous series of cells, the desktop version does not count blank cells (good) and the pocket excel counts blank cells as zero (bad).
Is there another formula I can use to average these cells so that it will not count blank cells on Pocket Excel

=AVERAGE(H4,L4,P4,T4,X4,AB4)

Surprising!

Try:

=SUM(H4,L4,P4,T4,X4,AB4)/MAX(1,COUNT(H4,L4,P4,T4,X4,AB4))