unable to add data using sumifs

[anillinda]

I am unable to get sum total for the following dataset:

the columns are as follows:
NO.
PAYMENT AMOUNT
INTEREST
PRINCIPAL (D11:D1054)
DATE WHEN PAYMENT IS DUE (I11:I1054)


MY FOLLOWING FORMULA FAILS AND I AM OUT OF LUCK!
=SUMIFS(D11:D1054,I11:I1054,"YEAR(2017)")
I AM TRYING TO CALCULATE PRINCIPAL PAID IN YEAR 2017. I ALSO WOULD LIKE TO CALCULATE PRINCIPAL BETWEEN TWO DATES SAY (08/1/2017 TO 07/31/2018)
.
THANK YOU,
SINCERELY,
NEAL SINGH

 

[AhoyNC]

You can use SUMPRODUCT to calculate the year.
SUMIFS between 2 dates.
You also may want to look at the CUMPRINC function which will calculate the principal between two periods.

Excel Workbook
	D	E	F	G	H
6	Year 2017 =	57
7
8	Start Date	8/1/2017	End Date	7/31/2018
9		122
10
11	25				7/12/2017
12	32				10/12/2017
13	25				5/6/2018
14	65				6/12/2018
15	25				10/12/2018
Sheet