CrispEXCEL Training & Consulting

Here is another alternative to summing the last n rows if you do not have #Office365 =SUM( (ROW(tblSales[Sales])>=LARGE(ROW(tblSales[Sales]),H3))*tblSales[Sales]) #Excel #DataChallenge #programming #cheatsheet