MS Excel 2010 if ifand formula

MS Office 2010, and function, or function, average function, count function

 

https://www.youtube.com/watch?v=6T7UfmSqJ8U