Hi,
Am running a sheet for my local darts competition. Got an issue when calculating a players average score. A darts average is the traditional way of measuring a players performance. It is points scored divided by darts thrown, multiplied by 3 (as there's 3 darts per throw).
So in my dummy sheet the player has in total scored 24801 in 1057 darts so his average should be 70.390. But the average excel is giving me when either highlighting or in a pivot table is 71.748. I can't see where the difference is coming from as all the individual legs (rows on the sheet) appear to be giving the correct average for each leg.
I get this on every player I am doing. Everyone is showing a slightly higher average than they should be. Can anyone see the reason for the difference? I'm sure there's a simple reason but I'm stuck as to what it is.
Bookmarks