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.
<tbody>
</tbody>
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>