You can easily get conditional average

=AVERAGE(IF(A1:A10="Frank",B1:B10))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

column A is the punters, B is the bet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ups.com...
Hi Guys,

Would appreciate a great help ...

I am entrusted to make the excel sheet for the Bundesliga here for the
only reason i come from India and i am supposed to know Programming.
Well jokes apart ... the excel contains the dates of the game, who all
betted for the game, and how did he / she bet at the end of the game
day. Finally it would be something like an average as to who bet the
most and who was the most successful.

I counted the number of bets made by person but was unable to make a
kind of an average and in the end who had the best average in making
the bets.

I can send in my excel file and explain accordingly ... i am totally
confused as i have no idea of betting too

Would sincerely appreciate all the help i can get

Best Regards
Shanker