Averaging Cells

inkblot · May 10th, 2002, 01:46 PM

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 · May 10th, 2002, 01:51 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 01:46 PM	#1
inkblot New Member Join Date: May 2002 Posts: 1	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)