b) if and or sumif

Click if and or sumif.xls link to view the file.