# Calculating averages and not including blank cells

Mercedes
Guest
Posts: n/a

 17th Feb 2010
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.

--
Of all the things I''ve lost, I miss my mind the most.

Bernard Liengme
Guest
Posts: n/a

 17th Feb 2010
But AVERAGE does ignore blank cells
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Mercedes" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
>
> --
> Of all the things I''ve lost, I miss my mind the most.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Suzy Microsoft Excel Worksheet Functions 20 18th Mar 2010 11:00 PM =?Utf-8?B?cm1lbGxpc29u?= Microsoft Excel Misc 6 6th Jul 2006 04:21 PM jrozendaal Microsoft Excel Worksheet Functions 1 15th Dec 2005 04:00 AM RICHARD Microsoft Excel Programming 0 15th Mar 2005 02:41 PM Pheasant PluckerŪ Microsoft Excel Misc 5 3rd Sep 2003 08:45 AM

Features