Determine LARGE with most recent data point excluded

Hello Matt,

I agree with pb71, I had trouble opening your sheet, best to post a version on here. I'm not sure what the issue is, pb71's suggestion will ignore the intermediate columns.......is it that they aren't every other column....are they evenly spaced?

pb71,

Don't believe you need ISNUMBER in any version [of excel], shorter version works fine....

regards, daddylonglegs

Hello Matt,

I think you can use the method I proposed previously, with a small tweak. The columns you want to consider all have "Combined" in row 6 so you can use this formula in B7

=SUM(LARGE(IF((V$6:CJ$6="Combined")*(T$5:CH$5<$A$3),V7:CJ7,0),{1,2,3,4,5,6,7,8}))

confirmed with CTRL+SHIFT+ENTER and copied down.....and given that non-qualifying columns show zero you don't need to make any special provision for less than 8 values - that will be accommodated automatically