SUMPRODUCT top 'x' percent of rows

I am sure this could be simple;

I am looking at to SUMPRODUCT the top 1% of the rows - which will be dynamic obviously, but am having trouble finding the correct formula. I have been monkeying around with AGGREGATE and with all of the PERCENTILE functions but can't seem to figure it out.

The column I am trying to sum is Col Q

Cell designation:

L3: =SUMPRODUCT(--($D$18:$D$35000<>"")*1%)

C13: ="Q1:Q"&L3

D15: =COUNTA(B17:B150015)+16

C15: ="Q17:Q"&D15


My current formula that is working

=SUMPRODUCT(LARGE(INDIRECT(C15),ROW(INDIRECT(C13))))



I am wondering if there is a NON VOLATILE way to do this using formulas / calcs only (no pivots or tables)
I don't mind using =SUM ( IF, however want to avoid SUMIF, SUMIFS at all measures as well, any insight would be appreciated

newdoverman,

If I could hit your rep button 100 times I would.

I am familiar with dynamic formulas - i.e. IF(ROWS$"":"">.......ROW($"":$"")-ROW($"")+1 but holy crap I have been trying to think how to do this for almost half the day.
The other one that was completely wrong I was messing around with was {=SUM(IF($Q$18:$Q$35000>PERCENTILE($F$18:$F$35000,0.01),$Q$18:$Q$35000))}

I can't thank you enough