SUM across rows (variable) until value is reached

Hi guys,

I need some help on this. I'm working on a formula that sums across the last few rows until the total reaches 14.

The values in the cells will range from 1-4, "US", "H", "FT" or left blank, and I only need to sum the numbers.


here's the closest I could get but it still does not meet my requirement because the range of cells should not be a fixed number (in this case is -14)

SUM(OFFSET(INDIRECT("RC",FALSE),0,0,1,-14))>14

anyone has an idea?


Book1.xlsx