Hi folks
I have a spreadsheet with rows of numbers. I would like to average the last 4 entries in each row each time I add a new number. The problem I am having is that occasionally I will have to leave a cell blank . I have 2 formulas the first being =AVERAGE(OFFSET(INDEX(2:2,,COUNT($A$2:$S$2)),,-3,1,4)). This works
but the problem is it counts the blank.
The second, =AVERAGE(IF(ISNUMBER(A5:Q5),A5:Q5)) ignores the blanks but I can’t figure out how to get it to only go back 4 data entries. Any Ideas would be appreciated
I have a spreadsheet with rows of numbers. I would like to average the last 4 entries in each row each time I add a new number. The problem I am having is that occasionally I will have to leave a cell blank . I have 2 formulas the first being =AVERAGE(OFFSET(INDEX(2:2,,COUNT($A$2:$S$2)),,-3,1,4)). This works
but the problem is it counts the blank.
The second, =AVERAGE(IF(ISNUMBER(A5:Q5),A5:Q5)) ignores the blanks but I can’t figure out how to get it to only go back 4 data entries. Any Ideas would be appreciated