Robust Summing based on date criteria

[mike4777]

I cannot use the mini-sheet as I do not have authorization to install unauthorized programs on my desktop.

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).

 

[mike4777]

Just in case my above language is confusing, I just need each row in column b (on pic) to look at its associated date (month/year) and find all of the dates in column D that exist inside the month/year of Column A and sum those days (column E).

 

[mike4777]

Figured it out. NM.