Been struggling trying to come up with an average calculation that allows me to only sample the last 10 days, on a continuous basis.
I would like to add new data to my spreadsheet everyday and not have to re-write the average formula to only sample the last 10 days(or 7 days)
below is a sample of my data, in a1 I have =today() command and in a3 I have a formula that reduces date by 10 days.
any help would be appreciated. I have tried averageif averageifs - guess I just don't understand what I am doing wrong.
* edit: also if anyone can help me with my trending formula in the first row, it seems to only trend from high to low.
I would like to add new data to my spreadsheet everyday and not have to re-write the average formula to only sample the last 10 days(or 7 days)
below is a sample of my data, in a1 I have =today() command and in a3 I have a formula that reduces date by 10 days.
any help would be appreciated. I have tried averageif averageifs - guess I just don't understand what I am doing wrong.
* edit: also if anyone can help me with my trending formula in the first row, it seems to only trend from high to low.