Is there an equation in Numbers that will give me the sum of numbers based on a separate column?

I'm trying to find out if there is a way to create an equation that looks at one column, if it is equal to a certain value, then add the value in the other column?

Example:

#Table of running values:

Type     Cost
-------------
A        $4
B        $2
B        $1
A        $6

I'd like to be able to create another table that results with this:

# Summation of each type

Type     Total
--------------
A        $10
B        $3

Any help in setting up an equation to do this summation would be helpful.


Solution 1:

I figured it out. The method is called =SUMIF(). I am so happy. :)