A | B | C | D | E | F | G | H | I | J |
30 | 41 | 37 | 69 | 46 | 32 | 40 | 33 | ||
What formula could I use to average the last 3 values of row A1 through J1 while ignoring the blank cells? This would have new data entered daily, so the row with be ongoing, let's say A1:YA4. As new data is entered, I always want the formula to calculate the last 3 values entered. I appreciate any help you might give