Home > Money Management > excel formula help. i am trying to organise myself in my money management. am trying to sort out like expenses?

excel formula help. i am trying to organise myself in my money management. am trying to sort out like expenses?

August 14th, 2012 Leave a comment Go to comments

this would be my pesonal money management:
salary 2500
gas -35
walmart -20
gas -35
phone -60

is there any formula that can retreive the total gas expenses in the table. like my be using the if condition. i donno. i need help.

thanks in advance.
f. Sanford. Thank You for your answer. thts exactly wht i was looking for.

appreciate your help.

=SUMIF(A1:A5,"gas",B1:B5)

Categories: Money Management Tags: , , , , , , , , , ,
  1. GoddessParis
    August 14th, 2012 at 08:30 | #1
    Reply | Quote

    I use the Suze Orman expense sheet which breaks down every expense imaginable and lets you know the real # of how much $ you spend on a monthly basis. Check it out.

    It’s http://www.suzeorman.com
    go to the bottom left hand side of the page under SUZE’S EXPENSE SHEET
    References :

  2. Madoff
    August 14th, 2012 at 08:48 | #2
    Reply | Quote

    I have a check register and budgeter that I found by googling
    excel check register and budget
    I just dont rememeber the site.
    Spend some time googling around – lots of free stuff.
    Mine shows me pie charts and graphs…..
    References :

  3. tahirih m
    August 14th, 2012 at 09:12 | #3
    Reply | Quote

    you know what ever formula do you know and have if you have no decipline in wasting your money …its gonna be useless

    so apply all your formula + decepline = good budget
    References :

  4. F. Sanford
    August 14th, 2012 at 09:21 | #4
    Reply | Quote

    =SUMIF(A1:A5,"gas",B1:B5)
    References :

  1. No trackbacks yet.