Accounting Excel Sheet Formula's

Dear Friends,

May I be please assisted with the following formula's to an Accounts sheet I created. It is attached.

A) If B4 contains letter "C", and C5 contains "Expense" Then add the total sum to H6.
B) If B4:B200 contains letter "B" and C5:C200 contains "CollectedMoney" Then add the total sum to l10
C) If B5 contains the letter "C" and D5 contains "MoneyCollected" Then add sum total to l19
D) How to I track amounts that are Undeposited for H11?

Thank you!