Jun 09 2019 10:16 AM
Here's my problem. I have a poker spreadsheet for let's say 30 people. Spreadsheet shows how each person finished each month and the points awarded for each month and then automatically adds up each months points for a overall point total. Can I add to the formula and ask to SUBTRACT the LOWEST 2 months out of the 12 months?
Jun 09 2019 11:33 AM
@RedIce ,
That could be
=IFERROR( SUMPRODUCT($B2:$Y2*(MOD(COLUMN($B$2:$Y$2),2)=1))- SUM(AGGREGATE(15,6,1/(MOD(COLUMN($B$2:$Y$2),2)=1)/(LEN($B2:$Y2)>0)*$B2:$Y2,{1,2})) ,0)
It ignores blank cells but takes into account cells with 0, and return zero if you have only one result.