specify sum cells

[chwein]

how to specify a sum cell when i got multiple sum columns which giving a total row

 

[earthworm]

Uses SUMIFS with criteria ">"& 0 for Deposit and "<"&0 for Withdrawl

 

[chwein]

Uses SUMIFS with criteria ">"& 0 for Deposit and "<"&0 for Withdrawl

Thanks but I'm a little new to excel can you please give more detailed ?
Thanks, I'm appreciating... ?

 

[earthworm]

Thanks but I'm a little new to excel can you please give more detailed ?
Thanks, I'm appreciating... ?

Book1
	A	B	C	D	E	F	G
1	Deposit	Withdrawl			Chase	Discover	Capital One
2	30	0			10	10	10
3	0	-21			-7	-7	-7
Sheet1

Cell Formulas
Range	Formula
A2:A3	A2	=SUMIF(E2:G2,">"&0,E2:G2)
B2:B3	B2	=SUMIF(E2:G2,"<"&0,E2:G2)

 

[chwein]

Book1
	A	B	C	D	E	F	G
1	Deposit	Withdrawl			Chase	Discover	Capital One
2	30	0			10	10	10
3	0	-21			-7	-7	-7
Sheet1

Cell Formulas
Range	Formula
A2:A3	A2	=SUMIF(E2:G2,">"&0,E2:G2)
B2:B3	B2	=SUMIF(E2:G2,"<"&0,E2:G2)

Thanks but it's not exactly what I want, maybe I didn't describe it well, so I'm NOT trying to divide it to all 3 I'm trying it should go to only one of the banks, like if the deposit was to chase only chase should get edited, I don't want to add another deposit/withdrawal for every bank, and not make it in every row manually,

 

[Joe4]

How can we determine what institution each transaction is to be applied to?
I am not seeing anything on the rows that indicates if it is for Chase, Discover, or Capital one?.