HELP: I want (VLOOKUP) to add up categorised spending by date

In my personal finance sheet I have 4 charts.

Chart 1 has columns Date, Action, and Balance. The dates are for a full month. Here in the "Action" cell, I want a formula to lookup and add together the total spending for that day according to the charts 2, 3 and 4.

The charts 2, 3 and 4 have 2 columns: Date and amount. They are for categories A, B and C respectively.

I would want the "Action" column cells in the first chart to calculate the spending on the date defined in the cell left to it, by looking into 3 different tables, and adding together the values in the second column of those 3 tables for the day. All days won't have entries.

Hope someone understands what I'm trying to say, I'm a big time excel newbie.

VLOOKUP will return a single value - you probably need to use SUMIF or SUMIFS, but as Richard says, it would help if you attached a sample Excel workbook.

Pete

Here is the attachment! Thank you for welcoming me.

Thanks that did it! Better revisit some SUMIFS tutorials to know how it works.