July 9th, 2020 
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
Posted in 