Thread: Calculating averages and not including blank cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
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 With QuoteReply With Quote