blank cells are treated as zeros how do I stop that
Great, Thanks
"Gary''s Student" wrote:
instead of
=(A1+A2)/2
use:
=AVERAGE(A1:A2)
AVERAGE will ignore blanks
--
Gary''s Student - gsnu200718
"Jez" wrote:
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.
"Gary''s Student" wrote:
post an example
--
Gary''s Student - gsnu200718
|