Thread: Formula assistance for gymnastic scoresheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default Formula assistance for gymnastic scoresheet
"Lisa W" <Lisa wrote:
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?

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" <Lisa wrote in message
...
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?

Reply With QuoteReply With Quote