How to sum daily interest from 10th of each month to 9th of next month

I have a spreadsheet that has a list of interest accrued, daily, over 4 years. Something like:

INTEREST

21/10/25 $5.10

22/10/25 $2.67

23/10/25 $7.89

I am trying to use sumifs and edate together to sum all the figures for a given month starting from the 10th of the month, so that I can drag the formula through to apply across the 4 years. But I’ve twisted myself into a mental pretzel and can’t seem to make it work.

I would like the end result to be one figure per month, displayed next to the 9th of the month.

So for 9th May 2026, the figure would be the sum of all interest from 10th April 2026 to 9th May 2026.

Does anyone know how to untangle this one? Help would be very appreciated.

Additional info:

• Excel Version (Microsoft Office LTSC Professional Plus 2024)
• Excel Environment (desktop, Windows)
• Excel Language (English)
• Your Knowledge Level (Beginner to Intermediate)

Syntax:

The dates are entered as DD/MM/YY (which seems to update automatically in the body of the cell to DD/MM/YYYY, then displays when the cell isn’t clicked as DD-MM-YYYY).

Where I‘m getting stuck:

- I‘m working on the premise that I’d need to make a set of formulas that:

(a) extract the date within the month; and

(b) then specify that if it’s exactly the 9th, then sumif from the 10th of the prior month up to and including that day.

- I can’t seem to isolate how the sumif function can do that.