I would like to average the last 4 entries each time i add one

T

tourglide

Joined
Mar 22, 2011
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average last 3 entries 3
Average last 4 entries in a row. 8
automatically average the last 4 columns 10
The Last of Us - Part I (PC) 6
Formula to average last 25 entries in a column? 4
Average of the last x entries with conditions 3
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
AVERAGE last 4 Mondays? 1

Top