Super User is a question and answer site for computer enthusiasts and power users. 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 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
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


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.