Multpiple tabs - calculate sum of borrowings and interest for month

I have to summarise what we borrowed for a month and what interest is due for that month.

There are two schedules. one at 9% and one at 8% I have to add the principle together and the interest is in seperate tabs.

I have searched through here and i know it will more than likely be sum ifs but i just can't work it out as it is over an 18month period and I'm getting confused with the years.

Sheet attached.

If I understand what you require ....

In C3

=SUMIFS('9% Interest Rate'!D:D,'9% Interest Rate'!A:A,">=" &'Interest Summary'!A3, '9% Interest Rate'!A:A,"<=" &EOMONTH('Interest Summary'!A3,0))

Copy down

Hey John

I am assuming i can just change the 9% to 8% and then for the principle I can just add the two formula's together?

=SUMIFS('9% Interest Rate'!D:D,'9% Interest Rate'!A:A,">=" &'Interest Summary'!A3, '9% Interest Rate'!A:A,"<=" &EOMONTH('Interest Summary'!A3,0))+=SUMIFS('9% Interest Rate'!D:D,'8% Interest Rate'!A:A,">=" &'Interest Summary'!A3, '9% Interest Rate'!A:A,"<=" &EOMONTH('Interest Summary'!A3,0))

I am no financial expert : simply adding the SUMIFS will give the total monthly interest payments on the loans.

=SUMIFS('9% Interest Rate'!D:D,'9% Interest Rate'!A:A,">=" &'Interest Summary'!A3, '9% Interest Rate'!A:A,"<=" &EOMONTH('Interest Summary'!A3,0))+SUMIFS('8% Interest Rate'!D:D,'8% Interest Rate'!A:A,">=" &'Interest Summary'!A3, '8% Interest Rate'!A:A,"<=" &EOMONTH('Interest Summary'!A3,0))