Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 2 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 Lawson 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

 
discard

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.