FORMULA Requiring Multiple Actions

[mistytreasure]

I'm setting up a spreadsheet to track all my monthly expenses. I have categorized things into 29 categories and am entering each expense with a code "1" for Household Maintenance, "2" for Household Repairs, "3" for Mortgage Payment, etc, etc. I want to type in a formula that can add the sum all CODE 1,2,3 etc figures and place them in a single location for that Category.

Here is an example of the 4 columns and how it is entered. I will want to add the the two elevens and put them in the "DIAPERS" category in another column.

DATE: AMT DESCRIP CODE
5/3/11 $22.92 Amazon, Diapers 11
5/3/11 $50.00 ATM Withdrawl 23
5/3/11 $52.42 Guppy's, Gas 13
5/4/11 $14.22 Amazon, Wipes 11


Any ideas on how to type in formulas to achieve this?

Thank you very kindly!

[jeffreybrown]

Hello & Welcome to the Board,

With your given dataset in A1:D5 and the code 11 in F1, try...

=SUMIF(D2:D5,F1,B2:B5)

which gives me a result of $37.14

[mistytreasure]

Thank you very much! I'd have never found this!

[jeffreybrown]

You are very welcome...thanks for the feedback

If you are satisfied with the answer provided, please do not forget to mark the thread as solved.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save