Hello! if you have multiple conditions, the best thing to utilize is the function called AVERAGEIFS. AVERAGEIFS average depending on the criterias you have inputted. So this makes it more convenient rather than using the average function in conjunction with the IF Function


By the way, I also learned a couple of things here about use Average in excel, it might help you too!

https://www.efinancialmodels.com/kno...rage-function/


Hope this helps!