I have missing values in my data, which appear as blank cells. When I apply
formulae across these cells, it automatically assigns a 0 value to these
cells and includes them in the formula calculations.

I want these cells to be disregarded when I apply a formula to large
sections of data and to remain blank after the formula is dragged acros them.
I can't get this to work at the moment and have to go through my data
manually checking which values were blank, and then deleting the appropriate
cells.

Is there a formula / symbol that tells excel that a blank cell is missing
data and should not be included in subsequent analyses??

Thanks for any suggestions!!