Try

Just a slight modification to Cutter's formula...

=AVERAGE(INDEX(D3:AN3,COUNT(D3:AN3)-4):INDEX(D3:AN3,COUNT(D3:AN3)))

drag down