Want to add up the amounts in a single column but only if it matches a certin critera? Here is a quick how-to on how to do just that using the SUMIF function.
If you open up the "More help on this..." you will see the compleate syntax and tips for how to use the function.

Select the cell you want the results to appear and click on the "Formula Builder" icon. You will then be presented with a dialog that will let you input the arguments for the function. (see screenshot below)

As you can see from the screenshot below, the range is where we want to make our evaluation. This is set to column A, rows 4 to 9 (A4:A9) The criteria is set to match on the string "Account A" and the sum_range containes the values we want to sum up. (if it matches the criteria) In this example, this is column B, rows 4 to 9 (B4:B9)
