Calculating averages and not including blank cells

M

Mercedes

Hello all,

Could someone tell me how to calculate the average of a column in Excel that
has blanks? I don't want to include the blanks in the average. I tried
using:
=AVERAGE(E1:E18)

thinking that it would not include the blank cells as part of the
calculation, but then realized the error of my ways...

Your help is most appreciated!

M.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphing Question: Blank Lines Problem ? 2
Excel Sumproduct 0
Excel Add ^ to a row of cells containing letters 3
help with formula please 1
Concatenate a row that is selected and include blank cells 11
How to omit blank cells when calculating weighted averages 20
Excel Excel: average range of cells including zeros and excluding blank across sheets 0
calculating averages 4

Top