Pull data from other worksheet having unique,duplicate sum

[paradise2sr]

Hi,

I want to get data from Sheet 2 in Sheet 1 G column.If in Sheet2,B column is is repeated & if there is duplicate then do sum and resulting figure to be get pulled in Sheet1 G column.

In Sheet 1 ,D column there exists duplicate .Hence, only in once to be pulled and not twice as shown in G column.

Matching should be done from Sheet1

Kindly see attached file for the same.

[JohnTopley]

Try

in G3

=IF(COUNTIF($D$3:D3,D3)=1,SUMIF(Sheet2!$B$3:$B$8,$D3,Sheet2!$C$3:$C$8),"")

[paradise2sr]

Thanks 👍 it worked out