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)
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)