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.