-2

I am trying to use a formula to get sum of one item from a Column that contains several items.

enter image description here

Improve this question
1
  • It isn't clear what you're trying to do. By definition, a sum is the addition of multiple items. If you want a single value, you would need a formula that identifies that value. It would help to add a specific example to your question to illustrate.
    – fixer1234
    Jan 10, 2018 at 18:31

1 Answer 1

Reset to default
1

To sum, for example, the SLEEVE items,

=SUMIF(C4:C39,"SLEEVE",D4:D39)
Improve this answer

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