Ever want to add up only SOME values in a column, or only count values whether or not they had a certain value? Well you can do this using SUMIF and COUNTIF, respectively.

Here's a new free tutorial in the TIPS section:

/tips/excel/sumif-countif/