Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a sheet that I'm calculating particular costs. These costs have associated labels to them: Manufacturing, Variable, Both, Neither. I have created a drop down list for next to the costs that selects these categories, what I want to do is in a separate cell, calculate the sum of costs based on the labels: (to calculate variable costs i need to add categories Variable and both, etc). Any ideas?

alt text

share|improve this question

1 Answer 1

up vote 1 down vote accepted

SUMIF should work just fine for this.

Let me know if you need suggested syntax.

share|improve this answer
    
Worked great! Thanks –  KronoS Sep 2 '10 at 17:58
    
Glad it helped! –  JNK Sep 2 '10 at 18:06

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.