How would I program this into my Excel Financial statement?

Ok, here is what I'm trying to do.



I have a sheet for my monthly income / expenses. I have a column labeled "LOCATION" which bascially tells me where the money went to / came from. For example, if I paid $5.00 cash for Ihop then the location would be selected as "Wallet". If I paid with my Debit card, the location would be "Checking"



"Location" is column D, "Expense" (numeric figure) is column F.



I have a separate spreadsheet titled "Monthly Summary". This spreadsheet lists summary data for ALL months - January through December. There is a "beginning" column, which labels how much money I had in each location at the start of the month and an "ending" column, which shows how much money I have at the end of each month.



Now... the question.



At the moment, I add something to the expense / income sheet for today. Then I have to transfer over to the monthly sheet and adjust the "ending" number to reflect the purchase



I spent 7.75 at Mcdonalds using my checking account. I want Excel to take the 7.75 out of the ending column instead of me having to go do it again. How would I go about doing that?



THANKS!! :)How would I program this into my Excel Financial statement?
The SUMIF function would help you out here.



For example, if your original balance for checking was in A4 then your formula would look like this:



=A4-SUMIF(D:D,"Checking",F:F)



This will match the cells in column D for the word checking, and if it does it will add the value of F in the sum. This will check the work Checking case sensitive as well.