blank cells in calculating an average

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Richard,

try

= average(A1:E1)

include the entire row, it should exclude your blanks.

hth,
Steve
 
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.
 
Back
Top