In column A I have various accounts (A, B, C, D, E, etc.). In column B I have an amount of money deposited into the account in column A; in column C is the date of the deposit, and in column E is jumbled text, but each deposit includes the words "Dividend", "Interest", or "Capital Gain" somewhere in the jumbled text.

In column E, I want to sum all of, say, the Dividends per account per date; I want to match the account in column A with the text in column D. For example, I want column E to list the Dividends from Account A on any particular date. I think it has to do with the SUMIFS function with an accompanying AND function, but I cant figure out how to parse out the matching language (in this case "Dividend") from column D.

Here is as far as I got: Column E=Sumifs(And(A:A="Account A"),(D:D="*Dividends*"),B:B), but it doesnt seem to work.
Any ideas?