I'm having problems setting up a formula.
This is what I have so far: =IF(AND(ISBLANK(E19),ISBLANK(F19)),0,INDEX(H10:H100,MAX((ABS(H10:H100)>0)*ROW(H10:H100))-(CELL("Row",H10)-1))+F19-E19)
I have an 'if' function, so if two cells are blank, then a 0 is returned in the total column.
Later if one of these columns is filled, then I want the figures added up. The issue is it takes the earlier 0, giving an incorrect total.
What I am trying to do is use a function to find the last non-zero value and add this to give the correct running total.
In the workbook it either gives a 0 value or says 'volatile' and I don't know what this means or why it is displaying. Any help would be greatly appreciated.
This is what I have so far: =IF(AND(ISBLANK(E19),ISBLANK(F19)),0,INDEX(H10:H100,MAX((ABS(H10:H100)>0)*ROW(H10:H100))-(CELL("Row",H10)-1))+F19-E19)
I have an 'if' function, so if two cells are blank, then a 0 is returned in the total column.
Later if one of these columns is filled, then I want the figures added up. The issue is it takes the earlier 0, giving an incorrect total.
What I am trying to do is use a function to find the last non-zero value and add this to give the correct running total.
In the workbook it either gives a 0 value or says 'volatile' and I don't know what this means or why it is displaying. Any help would be greatly appreciated.