Help with formula.
I keep my checkbook on Excel. I am trying to create a sheet to see if my balance agrees with the bank. The sheet that contains the info is named “Checkbook”. On a separate sheet, I want the total of outstanding checks. When a check clears the bank, I put the letter P in Column G, which is beside the amount in Column F. I need a formula that will give me the total amount of checks that have not cleared using the “P” in Column G as the indicator.
I keep my checkbook on Excel. I am trying to create a sheet to see if my balance agrees with the bank. The sheet that contains the info is named “Checkbook”. On a separate sheet, I want the total of outstanding checks. When a check clears the bank, I put the letter P in Column G, which is beside the amount in Column F. I need a formula that will give me the total amount of checks that have not cleared using the “P” in Column G as the indicator.