MS Excel 2010 advance formula 07

if function, and function, or function, sumif function, sum function, advance formulas

 

https://www.youtube.com/watch?v=2mw1sIGtBdM