Hey Everyone, he's my snafu:
I have created a simple sheet for balancing my checkbook. Example Below:
Date #/Type Payee Amount New Bal.
7/31 Interest 0.16 $3.14
7/31 Deposit 525.47 $528.61
8/3 Trans Chk2Clb (25.00) $503.61
8/4 ACH GSMR (75.00) $428.61
8/5 ATM Walpole (40.00) $388.61
8/5 ATM Fee (0.75) $387.86
I would like to create a formula that would go through the "Payee" column, find all cells containing the value "Fee", then add up the values in the cells next to it, putting the total in another cell. Similarily, I would like to create 2 formulas that would go through all the values in the "Amount" column, totaling all the positive numbers, and then totaling the negative numbers in separate cells.
I'm trying to recreate what a bank statment would tell me. Any suggestions?
Thanks! Robbie
I have created a simple sheet for balancing my checkbook. Example Below:
Date #/Type Payee Amount New Bal.
7/31 Interest 0.16 $3.14
7/31 Deposit 525.47 $528.61
8/3 Trans Chk2Clb (25.00) $503.61
8/4 ACH GSMR (75.00) $428.61
8/5 ATM Walpole (40.00) $388.61
8/5 ATM Fee (0.75) $387.86
I would like to create a formula that would go through the "Payee" column, find all cells containing the value "Fee", then add up the values in the cells next to it, putting the total in another cell. Similarily, I would like to create 2 formulas that would go through all the values in the "Amount" column, totaling all the positive numbers, and then totaling the negative numbers in separate cells.
I'm trying to recreate what a bank statment would tell me. Any suggestions?
Thanks! Robbie