Can you delay a calculation until required data is entered?

[jkmclean]

When the data is entered in c,d and e in sheet 3 it immediatly updates the average column on the collation sheet.
Is there a way to delay the update where the 114.833 value is until the data entry is complete for the three entries?
As soon as the 104 is entered it changes the 114.833 to 132.1667.
The 174 is calculated based on the 132 instead of the 114.

Name	hcp	HGS	HSS	HGH	HSH	gms	Ave	Total Pins
Betty McLean	86	128	352	216.2	611.200	6	114.833	689
Jim Karasimos	83	140	366	223.7	603.600	6	117	702
Jack StevenHaagen	85	139	352	225.4	608.500	6	115.833	695
John McLean	27	212	584	239	665.000	6	180.5	1083
Verna Mortensen	57	162	450	222.3	622.800	6	146.833	881
Ken Killen	23	218	573	246.8	643.200	6	184.833	1109
Joyce Banks-Stevenhaagen	63	172	425	234.1	611.300	6	140.5	843
Alex McKinnon	102	101	289	203.6	596.800	3	96.3333	289
Linda Carter	88	142	377	218.5	606.500	6	112	672
Patricia Renaud	80	155	374	235.1	606.200	6	121.167	727
Dan Murphy	93	137	365	230.6	645.800	6	106	636
Evelyn Farrah	88	137	359	218.9	604.700	6	112.333	674
Gerry Revelle	54	202	469	250.6	614.800	6	149.333	896

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

From Sheet 3

Hits & Misses

Game 1

Game 2

Game 3

Team Series Scratch

Team SeriesHcp

Team Game

Team Game Hcp

Game1Hcp

Game2Hcp

Game3Hcp

# games

Average

Betty McLean

104

174.2

132.1667

<colgroup><col><col><col span="12"></colgroup><tbody>
</tbody>

 

[Chrisdontm]

I'm not sure what row you are on in Sheet 3, but you can adjust as necessary...

Try something like this;

=IF(OR(C2="",D2="",E2=""),"",AVERAGE(C2:E2))

 

[hrayani]

another way

=IF(COUNTA(C2:E2)=3,AVERAGE(C2:E2),"")

 

[jkmclean]

The cell with the value of 114 is on the collation sheet and it updates immediately after entering 104 on sheet 3.
the j13 on the collation sheet is calculated by dividing the total pins by the number of games. K13/i13 on the collation sheet.
When I enter the 104 value on sheet3 the collation sheet is updated with a value of 113.
Total pins is calculated with the following
=SUMIF(Sheet3!A$3:A21720,C13,(Sheet3!C$3:C21720)) +SUMIF(Sheet3!A$3:A21720,C13,(Sheet3!D$3:D21720)) +SUMIF(Sheet3!A$3:A21720,C13,(Sheet3!E$3:E21720)) +SUMIF(Sheet3!R$3:R21720,C13,(Sheet3!T$3:T21720)) +SUMIF(Sheet3!R$3:R21720,C13,(Sheet3!U$3:U21720)) +SUMIF(Sheet3!R$3:R21720,C13,(Sheet3!V$3:V21720))
I need some way to pick up the value from j13 and use it to enter and calculate the values on sheet3.
game1, game2 game3 with hcp on sheet3 (174.3 value)is calculated by
=IF(C126="","",(((210-INT(INDEX(Collation!$J$13:$J$59,MATCH($A126,Collation!$C$13:$C$59,0))))*0.9)+C126))

Name	hcp	HGS	HSS	HGH	HSH	gms	Ave	Total Pins
Betty McLean	87	128	352	216.2	613.900	7	113.286	793

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>