blank cells are treated as zeros how do I stop that

J

Jez

When performing calculations blank cells are assumed to be zero values how do
I stop that i.e. blank cells should not be used in the calculation at all?
 
J

Jez

E.g Row 1 contains results for samples taken in the morning Row 2 results for
samples taken in the afternoon. I want Row 3 to be the average of the 2
samples so set up for a3 = (a1/a2) and copy the formula across the row,
however some samples are missing therefore say e.g. column z has no afternoon
sample (z2 is blank) and the morning sample gives a value of 1 (z1=1), z3 =
0.5 when is should be 1.
 
Top