Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 3 down vote accepted

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

share|improve this answer
You can accept your own answer if it solves your problem. – Daniel Nov 8 '11 at 20:11
Thanks. I just had to wait till enough time passed so I could. – RyanJM Nov 9 '11 at 15:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.