SUMPRODUCT for particular dates

[cwik1]

I made this worksheet some time ago, and in the mean time I managed to forget everything I knew/learned about excel. So thank you guys for the help.

So basically I have this function:

=SUMPRODUCT((Bankroll!$AA$14:$AA$6000<>"")*(MONTH(Bankroll!$AA$14:$AA$6000)=1)*(YEAR(Bankroll!$AA$14:$AA$6000)=2007)*(Bankroll!$AD$14:$AD$6000))

In the worksheet

Column AA is the Date
Column AB is the type of transaction (deposit, withdrawal, bonus, ect.)
Column AD is the Amount

So to the previous function, I want it only to sum column AD (Amount) when column AB (Transaction) says "Deposit" and/or "Withdrawal".

Thank guys.

[cwik1]

nevermind I think I figured it out.

=SUMPRODUCT((Bankroll!$AA$14:$AA$6000<>"")*(MONTH(Bankroll!$AA$14:$AA$6000)=12)*(YEAR(Bankroll!$AA$14:$AA$6000)=2007)*(Bankroll!$AD$14:$AD$6000)*((Bankroll!$AB$14:$AB$6000="Deposit")+(Bankroll!$AB$14:$AB$6000="Withdrawal")))