How to Subtotal with Text Criteria

Update. I have attached the sample Excel file and added a little more detail to my question. Thanks again!

Apologies, I've searched the forums, but can't find the exact answer.

Here is the problem I have. I would like to subtotal values from Column C, when a filter is applied to either Column A or B or both. Right now, I am only able to calculate the total even when the filter is applied.

For example, if I filter Column A (Year) for "2023", then my expected result is E1 = $60,000 and E2 = $12,000 or if I filter Column B only (Expense) for "Travel", then E2 = $27,000.

Attachment 862910

Screenshot 2024-03-14 at 11.05.51 PM.png

Thank you in advance for your advice.