Sleep Study

I am going to upload an excel spreadsheet that I am working on. The whole point of this project is to do nestedifs, lookups , sumifs , sumaverages. The professor gave me feedback and said that its looking good. The only thing its missing is some data charts and the sumifs, averageifs, nestedifs, date/time functions stuff like that .  The website where I got the information is  https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5536318/
I cant figure this out . I did a vlookup but its needing more .  For the most part its done, I just need those data charts and excel functions.
i.    An IF() function with An AND() or OR() function
ii.    Date/Text functions
iii.    A VLOOKUP() or HLOOKUP()function
iv.    A COUNTIFS(), SUMIFS(), AVERAGEIFS() type function