SUM and IF functions

[coatesie]

Hi,
I've had a bit of alook around teh foru and can't find an answer to my problem.

I'm writing a budget spreadsheet. I have a transaction ledger sheet and another sheet called account.
What i want to do is enter transactions in the transaction ledger sheet and assign them a category. I then want to sum all the amounts with the same category and month in the account sheet.

I really thought i had the right formula but it keeps returning nothing whe i do have something. there seems to be a problem with the SUM part of the function.

[Ace_XL]

Use SUMIF

In D6 of Dahsboard sheet..
=SUMIF('Transaction Ledger'!$G$4:$G$38,B6,'Transaction Ledger'!$E$4:$E$38)
and drag down

[coatesie]

OH thank you very much this has been bugging me all day. can't believe there was actually a function for what i needed to do.