Try this variation in Cell S4:
=SUM(LARGE(OFFSET(R4,0,-18+LARGE(IF(D4:R4<"",COLUMN(D4:R4)),6),1,19-LARGE(IF(D4:R4<"",COLUMN(D4:R4)),6)),{2,3,4,5}))
(remember to commit that array formula by pressing [Ctrl]+[Shift]+[Enter])

Does that work for you?

Ron

"TBD" wrote:

Hi Ron,
The formula you sent me works great as is, however when I made
modifications to the sheet it somehow went awry. The columns I used were
the team # in B4, team name in C4, the 16 weeks in D4:R:4 and the total
in S4. The modifications I made were to change yours to reflect Row 4.

=SUM(LARGE(OFFSET(R4,0,-16+LARGE(IF(B4:R4<"",COLUMN(B4:R4)),6),1,17-LARGE(IF(B4:R4<"",COLUMN(B4:R4)),6)),{2,3,4,5}))

I assumed R4 was to define the last week (16), and the -16 to reflect
how many columns to use and 17-, I'm not sure off. Using the above
formula it seems to pull the last 6 numbers, but not eliminate the high
and low score.