Microsoft Excel 2007 Advanced Functions: SUMIF
Almost every Exel user has encountered the SUM function. It is one of the most widely used functions of the Excel functions. And most Excel users will also have used the IF function. SUMIF function is a combination of the SUM and If functions which allows us to calculate the total of all cells within a given range that match a certain condition.