The SUMIF function can be used to sum a range on cells based on certain criteria.

With Excel 2007, Microsoft introduced another addition to SUMIF i.e. SUMIFS  that allows you to pass more than one criteria. Both SUMIF and SUMIFS  have been explained in the attached workbook. Try changing the values in yellow cells and see how the result under sales column changes...