Summing a range based on date matching

[Saeber4777]

The title makes it sound like a simple sumif function, but it is not.

I have two tables. Table 1 has a month by month break down of interest charged for that month. Table 2 has a daily breakdown of interest (simple interest accumulated daily and billed monthly).

Table 1 (simplified):

A1:B12 = Jan-Dec (formatted as 1/1/22)
B1:B12 = Interest for that month (formatted as currency)

Table 2 (simplified):

A1:A365 = 1/8/22 - 1-7-22 (representing 365 dates)
B1:B365 = Daily Interest

I need to sum the range (or a cell with that range already summed) for the daily interest to return to Table 1 (interest for the month). The issue is that the dates in table 1 may change regularly so I need a formula that can search table 2 for the matching days inside of the month criteria in table 1 and sum the interest. Otherwise stated, table 1 criteria = 1/1/22 so I sum all interest related to each day of Jan in table 2).

I tried using a sumif/index/match function but still only return the first daily interest rate (not a sum range).

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution

[Saeber4777]

Here is an example book.

[Saeber4777]

Anyone out there?

[Saeber4777]

Any help would be greatly appreciated. I've been trying to figure this out for days.

[Saeber4777]

nm, figured it out. It was a sumif function after all. Just had to use "=<"&CELL. I should have seen that.