Thanks:  0
Likes:  0

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.

2. Re: Formula for Checkbook Spreadsheet

Maybe:

=sumif(coulmn with p in it,"p",chech totals)

or like this

=sumif(g1:g100,"p",d1:100)

3. Re: Formula for Checkbook Spreadsheet

No, that didn't do it.
I want the sum of all amounts which do not have the "P" in the column beside it.

Thanks for the recommendation though.

4. Re: Formula for Checkbook Spreadsheet

=SUMIF(Checkbook!G2:G7,"",Checkbook!F2:F7)

That is provided the cells in G are blank if not cleared.

5. Re: Formula for Checkbook Spreadsheet

Welcome to the Board!

One word: Quicken

Why try to recreate the wheel?

6. Re: Formula for Checkbook Spreadsheet

Originally Posted by Smitty
Welcome to the Board!

One word: Quicken

Why try to recreate the wheel?

I just want to ride on it for a while!

Originally Posted by whitaker
No, that didn't do it.
I want the sum of all amounts which do not have the "P" in the column beside it.

Thanks for the recommendation though.

=sumif(g1:g100,"<>p",d1:d100)
I think this is how to express does not equal "p".

7. Re: Formula for Checkbook Spreadsheet

Did you try the formula I posted above?

8. Re: Formula for Checkbook Spreadsheet

My formula was based on your "requirement"

On a separate sheet...
So the formula offered would be placed in a cell on your "separate sheet"

9. Re: Formula for Checkbook Spreadsheet

I'm sorry it took me so long to get back to this, but I got side tracked. Yes, the formula worked like a charm. I just changed the row range to accomodate the specfic year I wanted to look at. Smitty (Moderator)mentioned Quicken. I use Excel extensively at work and have to write my own formulas to obtain the analysis I want. I want to understand formulas and their applications. The more I know about what can be done with formulas, the more capable I am to resolve data problems at work. I'm slowly learning, and quite pleased with the things I can do with formulas. However, I realize I have not scratched the surface. Thank you so much for taking the time to respond to the formula question.

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•