if column A and B got duplicates then sum only one row of Column C

[excelsql987]

I got two similar columns with the same data but I'm trying to sum only the first row of column C


https://app.box.com/folder/0

Thanks

[MarvinP]

Hi,

See the attached where I've done two helper columns to do your problem in two ways. You need the second helper in some way to see which is first. Hope this example helps.

Only use first of duplicates.xlsx

[ChemistB]

Hard to say from your very limited example. Maybe, in D2 copied down

=IF(COUNTIF($A$2:$A2, A2)=1, C2, 0)

[excelsql987]

Not exactly, I have many more line items. This is my fault.
I revised the example
Thanks


https://app.box.com/folder/0

[ChemistB]

You need to revise the example that you uploaded to this site as I do not have a App.box account to sign in to.

[excelsql987]

SumIfColumnsAreDuplicated.png

I hope this works better

[ChemistB]

Yes, that's what my formula does.
Did you try it? Note: it works because the second and third "A2" are not anchored.

[excelsql987]

Thanks a lot ChemistB , your formula : =IF(COUNTIF($A$2:$A2, A2)=1, C2, 0) works perfectly.
I guess I'm still puzzled because your formula ignores column "B"
but still I get the accurate results and that's what matter.

Thanks again for your quick help.