I am working on a budget spreadsheet. I have a tab that summarizes all individual account codes. The second tab is a transaction summary worksheet. In that worksheet there is a column that lists different account codes and adjacent to it the specific expense amount.

Is there a way that I can create a summary total of expenses based on one specific account code. For instance, all expenses that were account code '7001'.

A B C D
Date Account Code Description Amount
7/17/13 7011 W.B. Mason $33.20
8/21/13 7011 W.B. Mason $62.47
8/21/13 7011 W.B. Mason $3.79
9/4/13 7011 W.B. Mason $59.81
9/4/13 7011 W.B. Mason $61.05
9/11/13 7011 W.B. Mason $83.38
9/11/13 7011 W.B. Mason $3.39
9/11/13 7011 W.B. Mason -$3.39
10/23/13 7011 W.B. Mason $56.41
10/23/13 7011 W.B. Mason $35.72
10/23/13 7011 W.B. Mason $5.96
10/30/13 7011 W.B. Mason $32.39
12/4/13 7011 W.B. Mason $48.00
12/4/13 7011 W.B. Mason $5.96
12/11/13 7011 W.B. Mason $64.14
1/31/14 7011 W.B. Mason $34.68


Is there anyone that can provide me with a sample function code that I can use? Thanks!

-Ben