Adding the rows value if one column numbers match

Sir

Again I need another formula. I hope you help me like last time.

\1

Musiri4P.xlsx

As you see extent and total tax in D and E columns respectively.

Now I need to add those columns rows in G and H respectively only when PATTA NO in A column is same. like put in above screenshot.



It is tedious and error prone if done manually. So Please device any formula for this.

use in row 2

=IF(COUNTIF($A$2:$A2,$A2)>1,"",SUMIF($A$2:$A$1693,$A2,D$2:D$1693))

Copy down and across

See attached highlighted

In G2,

=IF(COUNTIF($A$2:$A2,$A2)=1,SUMIFS(D:D,$A:$A,$A2,$C:$C,1),"")

then copy to H2.

In I2,

=IF(COUNTIF($A$2:$A2,$A2)=1,SUMIFS(D:D,$A:$A,$A2,$C:$C,0),"")

then copy to J2,

Finally copy G2:H2, then fill down.