Hi all,
I'd love to get some help with a tricky formula! I'm trying to create rolling 30 day and 7 day scores and have tried the following after seeing it on a forum page:
=COUNTIFS(Projects!K2:K308,"Yes", Table1[Install date],">="&TODAY()-30,Table1[Install date],"<="&TODAY())/COUNTA(Projects!K2:K308)
However, this is showing the score out of all projects from all time, rather than just projects in the last 30 days.
Averages are on the Rolling Totals tab and data is on the Projects tab.
I've attached the data below (anonymised, of course), and would appreciate any help!
Thanks,
Martha
Bookmarks