I have a report that is able to pull/display values based on yesterday's Values. Is there a way I can modify the formula to ignore cells that contain zeros 0s and to continue to reference/pull the LAST cell that contains a numeric value?Current Formula=INDEX(SM!40:40,COUNTA(SM!A40:AG40))ScreenShot: 
Formula that Displays the Last Non-Zero Value Cell
google spreadsheets;formulas