blank cells in calculating an average

[Guest]

How do I exclude blank cells in calculation an average in excel. For examples

columns include the following

Blank 4 1 3

I want to include the blank cell in the formual, but want the average to be
based on 4, 1, 3 only. Ie. result should be 8/3 = 2.667

 

[Guest]

Richard,

try

= average(A1:E1)

include the entire row, it should exclude your blanks.

hth,
Steve

 

[Ragdyer]

A1 = 4
A3 = 1
A5 = 3
A2, A4, A6 are blank.
In A7 enter:

=AVERAGE(A1:A6)

 

[Myrna Larson]

If you look at Help for the AVERAGE function, you'll see it automatically
ignores blank cells and text. But it won't exclude cells that explicitly
contain a 0.