GBTIS
asked on
Average First 3 Values
I am trying to come up with a formula to average the first 3 values present in columns for individuals. Attached is some sample data. For Player 1 I basically want the average of 45,45 and 47. For Player 2 I want 39,42 and 44 and Player 3 47,44 and 48. Thanks for any help you can provide.
Average-First-3.xlsx
Average-First-3.xlsx
ASKER
That does not work if there is a blank value in the first 3 columns for a player. I should have been more clear I want the average of the first 3 non blank values in a set of data for each player.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, worked perfectly.
=AVERAGE(B2:D2)
That should do it.