Menu

Formula assistance for gymnastic scoresheet

Search this Thread

#1

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Scoresheet for car show	dan in TX	Excel Discussion (Misc queries)	0	April 20th 09 09:49 PM
Help Please with setting up a quiz scoresheet	MarkChambers	Excel Discussion (Misc queries)	2	April 11th 09 09:31 AM
Assistance with Formula	[email protected]	Excel Worksheet Functions	12	February 9th 07 08:52 PM
Formula Assistance Please	lorig_2000	Excel Worksheet Functions	0	July 19th 06 03:33 AM
HELP REQUEST:Golf Scoresheet question	Monte Comeau	Excel Worksheet Functions	3	May 9th 05 08:17 PM

All times are GMT +1. The time now is 10:47 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement