Formula assistance for gymnastic scoresheet

  • Thread starter Thread starter Lisa W
  • Start date Start date
L

Lisa W

I am trying to develop a score sheet for a gymnastics competition and need
help with the formulas. In one part of the sheet there are four judges for a
routine but on the day may only have 2 judges actually scoring. I need to
find the average of the 4 scores if there are 4 judges or average of 2 scores
if there are only 2 judges. How do I can the calculation to ignore blank
cells?
 
Lisa W said:
find the average of the 4 scores if there are 4 judges or average of 2
scores
if there are only 2 judges. How do I can the calculation to ignore blank
cells?
Click to expand...

That is exactly what the AVERAGE function does. But be sure the cell
appears blank (actually empty or text like ""), not zero.

Caveat emptor: A cell can appear blank, but have a value of zero due to
custom formatting.


----- original message -----
 
Lisa W said:
find the average of the 4 scores if there are 4 judges or average of 2
scores
if there are only 2 judges. How do I can the calculation to ignore blank
cells?
Click to expand...

That is exactly what the AVERAGE function does. But be sure the cell
appears blank (actually empty or text like ""), not zero.

Caveat emptor: A cell can appear blank, but have a value of zero due to
custom formatting.


----- original message -----
 
The AVERAGE function will ignore blank cells, so if your scores are in
A1 to A4 you can use:

=AVERAGE(A1:A4)

If you have blanks in any of those cells they will be ignored.

Hope this helps.

Pete
 
The AVERAGE function will ignore blank cells, so if your scores are in
A1 to A4 you can use:

=AVERAGE(A1:A4)

If you have blanks in any of those cells they will be ignored.

Hope this helps.

Pete
 
Back
Top