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