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

Excel Pivot Table 4
Graphing Question: Blank Lines Problem ? 2
Standard Deviation and Averages based on criteria 2
Concatenate a row that is selected and include blank cells 11
help with formula please 1
Average formula where blank cells are counted as zeros 4
A useful AVERAGE calculation without using the built-in AVERAGE function 3
Averageifs - criteria is cell is not blank 1

Top