Can I get a Sum From All Values in a column that have a specific value in the column next to them?

[Gryrok]

So, I'd like to have a list of transactions, and have each transaction be labeled something. Next to this list I'd like to have a total value of each transaction with a specific label. Like, if we were totally an amount spend on an event, we could say "$5" "Promotions" and "$10" "Services" etc. etc., and in the table next to that, it would, in a single cell, add the total value assigned each label, like it shows below.

What would I put in the cell shown below to get the total value of everything labeled A?


Thanks in advance for your help, and I apologize if this has been asked/answered, I tried searching for it, but I just don't know how to look or what to call it.

date	item	value		Total Values Based on Item
1-Sep	A	1		A	HOW DO I GET THIS CELL?
2-Sep	C	2		B
3-Sep	D	1		C
4-Sep	A	2		D
1-Sep	B	3		E
2-Sep	E	4
3-Sep	C	3
4-Sep	D	1
1-Sep	C	2
2-Sep	A	2
3-Sep	C	1
4-Sep	A	2

<tbody>
</tbody>

 

[Gryrok]

It looks like we all have missed the above.

Gryrok,

Can we see what other $ values, and, text, that go with the other etc.'s?

The Etc. were referring to more "Items" which could have been, for example, "Entertainment" "Donations" "Cleaning", or the like. In the sample sheet the Etc.'s are shown as D,E & F, but of course there is no realistic limit here, it could go well past Z into the AA's and beyond.

You all nailed it with the =Sumif(). I'll have to checkout =sumproduct() to see how that might be useful.

Thanks again!

 

[hiker95]

The Etc. were referring to more "Items" which could have been, for example, "Entertainment" "Donations" "Cleaning", or the like. In the sample sheet the Etc.'s are shown as D,E & F, but of course there is no realistic limit here, it could go well past Z into the AA's and beyond.

You all nailed it with the =Sumif(). I'll have to checkout =sumproduct() to see how that might be useful.

Thanks again!

Gryrok,

Thanks for the feedback.

You are very welcome. Glad we could help.

And, come back anytime.