I have a dashboard that summarizes several groups of statistics
I am trying to have one cell return the average of success % rates of all of the days in the week prior
DASHBOARD.PNG
This cell should look in columns in other sheets e.g :
RATES.PNG
My guess was that the formula would be an =AVERAGIFS( VLOOKUP()). But I did not want to get the syntax wrong, and wanted to return a value inclusive of the Friday listed on the dashboard.
I would greatly appreciate some assistance!
THANKS
Bookmarks