Pull SUM from drop down list

[madriz]

Hello, this is something small i am sure but would like some help solving..

Sheet 1 is an expense sheet
Columns
1. Name
2. Category
3. Deposit/ Withdraw
4. Deposit Amount
5. Withdraw Amount

Rows:
1. Person 1, Person 2
2. Rent, Credit Card, Savings, Vacation, Etc.
3. Deposit, Withdraw
4. + #
5. - #

How can I pull from a second sheet where a dropdown of the categories are available for choosing to add the total of column 4 & 5?

 

[GraH - Guido]

Look in the help for SUMIFS function. Should do what you want to achieve.