Ok, I have a worksheet that has data in 1 row under a date, listed for 30 days. I need a formula that will average only the last 3 values. eg. I only want the average of the data from the previous three days from today. This is driving me crazy! HELP!