How to add up different amounts into separate totals.

[morayweb]

Good evening.
i hope a can explain what I need.
i am doing a cash ledger with around 6 or 7 categories. What I am trying to do is total the amounts from each categories separately.

eg.
col1. Col 2
subscriptions. £25
events in. £34
subscriptions. £79
camps in. £25
camps in. £25

what I would like is to group them and have their totals separate

like subscriptions £106
Events in. £34
Camps in. £50

thankyou for any help.

 

[Joe4]

Welcome to the Board!

There are various ways to do this:
1. Use a Pivot Table
2. Use Subtotals
3. Use a SUMIF formula

Here are instructions on how to do a SUMIF formula: https://exceljet.net/excel-functions/excel-sumif-function

The other few methods are a little more involved. If you are interested in those, try Googling them for some good tutorials. You can find some visual tutorials on YoyTube too.