Variable cell reference in function array

[sportster]

A little background info on what I'm trying to do. I am creating a new race series points list, and want to create a function (self contained and copy-able all in one cell). It will be used to calculate the total race points in a 12 race series for all racers. The issue I have is: The series offers "drops" of your lowest 2 finishes. I need to be able to easily adjust how many drops and when they start taking affect. The main issue is making the formula only count the races that have been completed (via a cell reference variable) and not drop the future rounds without points

The current version of my formula is: =SUM(LARGE(E2:P2,ROW(INDIRECT("Z1:Z"&(12-$A$2)))))
$A$2 (cell A2) is where I have one variable, how many drops to count. This part works just fine.
The other variable I need to add in is for P2 in my formula. I want it to reference a number I can change in cell A4. This variable will allow me to only show results for the races that are complete (1-12), so that the lowest points drop does not drop the races that have not been run yet. After each race is complete and the points are updated I also need it to be able to resort the list based on the formulas output (located in column C)


I put a sample of what I'm trying up on Dropbox, so you can see it:
https://www.dropbox.com/s/np7d8pakhzxyn6b/2016_HARC_Points.xlsx?dl=0

 

[sportster]

In my linked xls file the TEST tab will be where the points will be stored for each class, I will copy & rename this for other classes