Sum Problem in Excel formula

[Nandan]

Dear All

I have excel like this

ColA ColB ColC
A 5
A 3 8
B 5 5
C 5
C 5
C 5 15
D 5
D 2 7
E 15 15
F 20
F 20 40

I want output like this i have write formula like this it sums duplicate value but dont display unique value.
Formula

[=IF(AND(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),COUNTIF(A:A,A1)>1),SUMIF(A:A,A1,B:B),"")]

Pls help me to solve this

Thanks & Regards


Nandan

 

[Aladin Akyurek]

Dear All

I have excel like this

ColA ColB ColC
A 5
A 3 8
B 5 5
C 5
C 5
C 5 15
D 5
D 2 7
E 15 15
F 20
F 20 40

I want output like this i have write formula like this it sums duplicate value but dont display unique value.
Formula

[=IF(AND(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),COUNTIF(A:A,A1)>1),SUMIF(A:A,A1,B:B),"")]

Pls help me to solve this

Thanks & Regards


Nandan

Let A2:B12 house the sample.

In C2 enter and copy down:

=IF(A2<>A3,SUMIF($A$2:A2,A2,$B$2:B2),"")

This assumes the items in A2:A12 are grouped together.

 

[Nandan]

Yes dear its working perfectly. another point is that i want to delete duplicate then what i have to do


Regards

 

[Aladin Akyurek]

Yes dear its working perfectly.

Great. Thanks for providing feedback.

another point is that i want to delete duplicate then what i have to do
Regards

If you literally want to get rid of the duplicate records, you'll need code in VBA. Hope someone into VBA takes this up.