On my data sheet from col D through col Z is where the data is kept. The numbers in in col D through col Z, can be both negative and positive numbers, so what I want to do is average, the last three numbers in the range for a three day average, and the last 5 days for a average, and the last ten. There will be zeros when no information is required. Also not all people will have a 10,5,3 day information for a average number.
Example:
col D row 3: 65.02
col E row 3: -2.03
col F row 3: .00
col H row 3: 15.00
col I row 3: .00
col J row 3: -.23
So the three day average should show 4.246. But when I use the average formula the result shows 2.548. So what type of formula would I need to get the correct results.