Thread: Average column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Average column

AVERAGE function ignores blank cells (but involves zero cells!)

Regards,
Stefi

ezt *rta:

I have a column of cells which contain some cells with values (ie:
4,6,3,5,7 etc.) and some blanks (cells which possibly will have values
if circumstances are right) I need to average the values but ignore
the blank cells. can this be done and how
Thanks
EJ