Excel offers a number of conditional IF functions such as COUNTIF and SUMIF which allow you to count or sum a range based on the values in another column. If you have Excel 2007 or later you’ll have the really...

function countifs rankif sumproduct

The sumproduct function is one of the most useful and powerful features of excel but the online help available from microsoft is unfortunately pretty poor.

function sumproduct