Find sum of difference in a single column based on criterias.

Dear Experts,
I need to find the sum of differences in a single column based on some criterias.
Please find the working file and details in the attachments

Also, please let me know if there is a better option to do what I have done there as I need to combine an array formula and a normal formula which I am unable to do.

I'm not sure I understood your issue. See if this is correct.

Originally Posted by jme1013

I'm not sure I understood your issue. See if this is correct.

I am sorry but I did not require manual formulas. Anyway, I have solved it . the formulas are as under:
Amendment in 2018 =SUM(IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0))
Amendment in 2019 =SUM(IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0))
Original in 2018 =SUM(IF(A4:A14=2018,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0)))
Original in 2019 =SUM(IF(A4:A14=2019,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0)))
Positive Differences 2018 =IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0)-IF(A4:A14=2018,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0))>0 IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0) A4:A14=2018 C4:C14 1 D4:D14 A4:A14=2018
Negative Differences 2018 =IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0)-IF(A4:A14=2018,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0))<0 IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0) A4:A14=2018 C4:C14 1 D4:D14 A4:A14=2018
Positive Differences 2019 =IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0)-IF(A4:A14=2019,IFERROR(LOOKUP(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),C4:C14),0))>0 IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0) A4:A14=2019 D4:D14 IF(A4:A14=2018,IF(D4:D14="",B4:B14))
Negative Differences 2019 =IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0)-IF(A4:A14=2019,IFERROR(LOOKUP(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),C4:C14),0))<0 IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0) A4:A14=2019 D4:D14 IF(A4:A14=2018,IF(D4:D14="",B4:B14))
Net Difference in 2018 =SUM(IF(D4:D14<>"",IF(A4:A14=2018,C4:C14,0),0))-SUM(IF(A4:A14=2018,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0)))
Net Difference in 2019 =SUM(IF(D4:D14<>"",IF(A4:A14=2019,C4:C14,0),0))-SUM(IF(A4:A14=2019,IFERROR(INDEX(C4:C14,N(IF(1,MATCH(D4:D14,IF(A4:A14=2018,IF(D4:D14="",B4:B14)),0)))),0)))