Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

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