Excel - Formula to get sum of debit/credit

Arow            B                                                                           C               D

24/01/2018	PAYMENT RECEIVED 000000000L1625996828275	Credit	2
25/01/2018	PETROL TRXN FEE RVRSL EXCLUDING TAX	Credit	2
3/1/2018	SWAGATH DE ROYAL HYDERABAD IN	Debit	10
4/1/2018	INDIAN RAILWAYS CA INR HTTPS://WWW.I IN	Debit	10
5/1/2018	BAR ONE HYDERABAD IN	Debit	10
5/1/2018	BAR ONE HYDERABAD IN	Debit	10

Now want to get sum of credit & debit like below

Credit	4
Debit	40

Ans: Formula : =SUMPRODUCT(($C$2:$C$222=Credit)*($D$2:$D$222))