Thanks but I'm a little new to excel can you please give more detailed ?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... ?
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,
Cell Formulas Range Formula A2:A3 A2 =SUMIF(E2:G2,">"&0,E2:G2) B2:B3 B2 =SUMIF(E2:G2,"<"&0,E2:G2)