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

R

retiredtchr

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

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)
 
Top