How to work out 3 dart averages

[Darts Daft]

I am wondering if any one can help how do i work out 3 dart averages on excel including missed darts and no score

 

[barry houdini]

Perhaps you can supply some [small] examples with expected results. How are you entering the data, each dart score in a separate cell?

 

[Darts Daft]

Perhaps you can supply some [small] examples with expected results. How are you entering the data, each dart score in a separate cell?

do yo have an email addy i will send the score sheet

 

[Snakehips]

DD,

Your best way to share a file is to put it on a share site such as DropBox and post a link. Not everybody will be prepared to download a file but many might.

One way or another, you need clearly define what you mean by 3 dart average.

Some say 3 x single dart average?
What about the effect of bust throws etc?

 

[Darts Daft]

Date CHECK Darts 3 Dart 100 120 140 180 Mach Average
Player leg 3 6 9 12 15 18 21 24 27 30 33 36 39 42 Out Used Avereage
100 150 3 60 100 100 3 82.6
60 60 60 60 60 60 60 60 60 60 60 60 60 60 60
#DIV/0!
#DIV/0!i
i had a try but not sure if i am right

 

[wideboydixon]

3 dart average can be taken either for the first 9 darts or for the whole leg. Here's an example:

Book1
	A	B	C	D	E	F
1	Starting Score	501
2	3 dart average for leg	115.6154
3	First 9 darts 3 dart average	135
4
5
6	Darts Thrown	3	3	3	3	1
7	Dart Scores	180	140	85	64	32
Sheet1

Cell Formulas
Range	Formula
B2	=$B$1/SUM($B$6:$K$6)*3
B3	=SUM($B$7:$D$7)/3

WBD