SUMIF based on duplicates?

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 1101
90.00 1101
$100.00 1300
$50.00 1300
$22.00 1300
$400.00 2400
30.00 2400
4000.00 2500


I would like to input a $ total in column D of each duplicate # in column C.
For example the $ total for 2400 is $430.00.

Sounds simple, but it is Friday and my brain is on Saturday mode. Is there
a formula I can input into column D?

Thanks for any help on this.

Why are you still working? :-)

Anyway first extract Unique nos from Col C
Data|Filter|Advance Filter|Copy Unique values to D1
(if you are not able to work this out then simply change D1 to C1... but
then you will get the same no for every occurence of value in C1 in Col C)

One you get the list in D (if you don't get the above simply type the nos)

Enter this in E1
=SUMIF(C:C,D1,A:A)+SUMIF(C:C,D1,B:B)

Now you can go and have a nice weekend...


"Tacrier" wrote:

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 1101
90.00 1101
$100.00 1300
$50.00 1300
$22.00 1300
$400.00 2400
30.00 2400
4000.00 2500


I would like to input a $ total in column D of each duplicate # in column C.
For example the $ total for 2400 is $430.00.

Sounds simple, but it is Friday and my brain is on Saturday mode. Is there
a formula I can input into column D?

Thanks for any help on this.

Good Question. lol

Thankyou for your speedy reply, I will try this formula out when I get to my
office this evening or tomorrow. Update on results coming soon!

"Sheeloo" wrote:

Why are you still working? :-)

Anyway first extract Unique nos from Col C
Data|Filter|Advance Filter|Copy Unique values to D1
(if you are not able to work this out then simply change D1 to C1... but
then you will get the same no for every occurence of value in C1 in Col C)

One you get the list in D (if you don't get the above simply type the nos)

Enter this in E1
=SUMIF(C:C,D1,A:A)+SUMIF(C:C,D1,B:B)

Now you can go and have a nice weekend...


"Tacrier" wrote:

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 1101
90.00 1101
$100.00 1300
$50.00 1300
$22.00 1300
$400.00 2400
30.00 2400
4000.00 2500


I would like to input a $ total in column D of each duplicate # in column C.
For example the $ total for 2400 is $430.00.

Sounds simple, but it is Friday and my brain is on Saturday mode. Is there
a formula I can input into column D?

Thanks for any help on this.

Your Data Filter/SUMIF combo worked in a matter of minutes (I would say
seconds, but it took me two tries to figure it out)

Again, Thank you!!

"Sheeloo" wrote:

Why are you still working? :-)

Anyway first extract Unique nos from Col C
Data|Filter|Advance Filter|Copy Unique values to D1
(if you are not able to work this out then simply change D1 to C1... but
then you will get the same no for every occurence of value in C1 in Col C)

One you get the list in D (if you don't get the above simply type the nos)

Enter this in E1
=SUMIF(C:C,D1,A:A)+SUMIF(C:C,D1,B:B)

Now you can go and have a nice weekend...


"Tacrier" wrote:

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 1101
90.00 1101
$100.00 1300
$50.00 1300
$22.00 1300
$400.00 2400
30.00 2400
4000.00 2500


I would like to input a $ total in column D of each duplicate # in column C.
For example the $ total for 2400 is $430.00.

Sounds simple, but it is Friday and my brain is on Saturday mode. Is there
a formula I can input into column D?

Thanks for any help on this.