# Sum of all values of a matching item

1. ## Sum of all values of a matching item

Hello,

As seen in the image below, I want to create a formula to calculate the sum of all values of a matching item, Item B (sum is 68).

Excel issue.png  Register To Reply

2. ## Re: Sum of all values of a matching item

Look at SUMIF / SUMIFS functions  Register To Reply

3. ## Re: Sum of all values of a matching item

I'm not good with formulas. Been struggling with this for a while now. Could you possibly share the formula? Anyway, I'm going to try those functions. Thanks.  Register To Reply

4. ## Re: Sum of all values of a matching item

It seems to work. What if I have a few columns in-between "Column A" and "Value"?

=SUMIF(A2:B12,"Item B",B1:B12)  Register To Reply

5. ## Re: Sum of all values of a matching item

Just change "Value" range

e.g if "Values" are in Column G

=SUMIF(A2:A12,"Item B",G2:G12)

Well done for attempting this.

Functions like these (COUNTIF/ COUNTIFS) are commonly used so learn how they work.  Register To Reply

6. ## Re: Sum of all values of a matching item

Thanks. I will try those.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 