Formula to Add unique and Duplicate entries

Dear All,
I have a problem as shown in the attached file

I want to sum my Ref No. (Col C)

If it is unique then the Total should show of the same row and
if the Ref no. is repeated then it should sum both the values in the Total Column.

I have made Col F as my desired result required
TIA
Sameer

No file attached

Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.

Try this in F2 copied down:

=IF(B2&C2=B1&C1,0,SUMIFS(E$2:E$38,C$2:C$38,C2,B$2:B$38,B2))

I'm thinking Pivot Table (which I don't know much about) or PowerQuery (which I know nothing about).

PowerQuery would require the downloading of the add-in if the OP is still using 2010, but yes, the data could be aggregated. However, the result would NOT be what the OP is showing in the sample file, either with PQ or a pivot table: it would be a summary view.

No problem.

In G2 then copy down.

=IF(COUNTIF($C$2:C2,C2)=1,SUMIF($C$2:$C$38,C2,$E$2:$E$38),"")