Logical Functions MSOfficeExcel 2007 Tutorial

Input the formula: =IF(A2=100,SUM(B5:B15),"")