I used this formula to average the last 10 results excluding blank cells. It works great but i have new people starting and they do not have 10 results so the cell is blank where the average from the formula should be. Wanted to know if there was a way to return the average of the last 10 results or the average of whatever is available. There will always be at least 1 number when somone is added to the sheet. I would like to add new people and add a new column right as the months are finshied
=IFERROR(AVERAGE(IF(COLUMN($B4:Q4)<=SMALL(IF($B4:Q4<>"",COLUMN($B4:Q4)),MIN(COUNT($B4:Q4),10)),IF($B4:Q4<>"",$B4:Q4))),"")
Capture.PNG
Thanks
Bookmarks