blank cells are treated as zeros how do I stop that

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
instead of

=(A1+A2)/2

use:

=AVERAGE(A1:A2)

AVERAGE will ignore blanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average formula where blank cells are counted as zeros 4
Create a simple average that does NOT include blanks cells 4
Blank Cells vs. Zero Values 2
Counting blanks as zeros 1
How does a function provide a blank cell as a result 2
Conditional Formatting 1
Linking sheets how do I display the zeros (0) as blank cells 1
Stop zero on cell 6

Back
Top