Accounting Excel Sheet Formula's

A) If B4 contains letter "C", and C5 contains "Expense" Then add the total sum to H6.
Expected Result: Dynamically total the amount of money added by above parameter to H6.

B) If B4:B200 contains letter "B" and C5:C200 contains "CollectedMoney" Then add the total sum to l10
Expected Result: Dynamically total the amount of money to l10


C) If B5 contains the letter "C" and D5 contains "MoneyCollected" Then add sum total to l19
Expected Result: Dynamically total the amount of money to l19

D) How to I track amounts that are Undeposited for H11?
Exexted Result: as "MoneyDeposit" are made, calculate how much money that was collected on hand, but not deposited to hte bank,
and add the answer to l19