View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa W[_2_] Lisa W[_2_] is offline
external usenet poster
 
Posts: 1
Default Formula assistance for gymnastic scoresheet

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?