I have read numerous posts and watched a thousand videos on how to correct a DIV/0 error but can’t seem to get mine to do the same. I am averaging cells C4 to F4. And as the cells are blank I want the averaging cell (G4) to also remain blank until data is entered (as it is the cell that has the #DIV/0 error). Is that possible?