What is the excel formula to calculate average value ignoring blank cells?

Answer 1

Excel already ignores blank cells when you use the Average function. However, it's different if the cells contain the value of 0.

If that is what you mean, instead of using =Average(), use =AverageIf().

The syntax requires the range of cells and the criteria.