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


SUMIF should work just fine for this.

Let me know if you need suggested syntax.

  • Glad it helped! – JNK Sep 2 '10 at 18:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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