=SUM(LARGE(B2:Z2,{2,3}))

--
HTH

Bob Phillips

"TBD" wrote in message
...
I tried some different functions like an array that I thought would work
but didn't. I realize that I will have to make another function to
figure avg, but would like to do the following in one cell.
A B C D E F G H I J K L M
1 Name: Wk1 Wk2 Wk3 Wk4 Wk5 Wk6 Wk7 Wk8 Wk9 Wk10 Total
2 Anybody 45 40 38 40 43 42 40 35


What I would like to do is take the last 6 scores, throw out the high
and low and take the total of the remaining 4. Taking into
consideration that some people will not be there some weeks.
I did a google search and came up with some array formulas, that took
the last 3 scores (didn't work) but had no way to delete out the high
and low anyway.