Excel Formula To Average Non Blank Cells. In the example shown the formula in E5 is. Prepare below table.
Press the up-arrow key. G3 is the average of 2 and 2 since one cell is blank it should not be factored in 222 valid cells G4 is 3because one cell is zero one cell is blank and one cells is 3 therefore its computing 31. Function checks the cell D5.
Press the up-arrow key.
AVERAGEIFS price group where price C5C15 and group D5D15 are named ranges. Follow the following steps to use a formula to copy the value from the cell above. AVERAGEIFS Average_range range. This cell reference can be changed as you need.