Hi all,

How can I create a simple average calculation that does not include a cell
that's blank.

For example, I do a simple average all cells A2:A10. BUT, if one of those
is blank, it treats is a 'zero' and skews the average calculation. I don't
want it to include the blank cells as part of the formula. Only when a
number is entered into one of the cells should it be included in the Average
function.

Can this be done? Thanks so much!