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?


#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.


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

|improve this answer|||||
  • Thanks. I just had to wait till enough time passed so I could. – RyanJM Nov 9 '11 at 15:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .