Home > OS >  Is it possible to average a value over the last 5 days based on criteria?
Is it possible to average a value over the last 5 days based on criteria?

Time:03-10

I am trying to find the average of certain NBA data points over the last 5 and last 10 days. I want to know, for example, how many FG an opponent allowed over the last 5 days. I also want to calculate how many FG an opponent allowed over that time frame to a specific position. How could I go about doing that? I have attached the raw data in a googlesheet below.

enter image description here

  • Related