Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 12
Default Calculating averages and not including blank cells

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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 563
Default Calculating averages and not including blank cells

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

"Mercedes" wrote in message
...
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to omit blank cells when calculating weighted averages Suzy Excel Worksheet Functions 20 March 18th 10 11:00 PM
Averages with blank cells and specified criteria MaryH New Users to Excel 5 May 24th 06 08:07 AM
Average range including blank cells: #DIV/0! Areaka Excel Worksheet Functions 3 April 12th 06 10:21 PM
how to combine including blank cells Karmen New Users to Excel 7 March 15th 06 07:14 PM
Calculating without including Hidden Cells LiquidFire Excel Discussion (Misc queries) 3 November 29th 04 09:35 PM


All times are GMT +1. The time now is 08:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"