How do I sum transactions for one bank when 4 banks are listed?

[retiredtchr]

Can you demonstrate an example of using SUMIF to add transaction totals for
each bank that is listed on the same worksheet?

 

[JE McGimpsey]

One way:

A B
1 Bank Transaction Amt
2 Execrable Trust 20
3 Debit Credit Union -10
4 A&B S&L 17
5 Execrable Trust 9
6 Debit Credit Union -100
7 Execrable Trust 203
8 Debit Credit Union 150
9 A&B S&L 37


=SUMIF(A:A,"Execrable Trust",B:B)

 

[ryguy7272]

Another way:
=SUMPRODUCT(--(B2:B9="Execrable Trust"),--(C2:C9))