G Guest Nov 1, 2007 #1 Can you demonstrate an example of using SUMIF to add transaction totals for each bank that is listed on the same worksheet?
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 Nov 1, 2007 #2 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)
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)
