find repeating values

[Alex Kachanov]

Hi!
How can I find sum of repeating values in column? What formula should I use?
Thanks.

________________
Alexander Kachanov aka Alex29
(e-mail address removed)
ICQ# 14840340

 

[Leo Heuser]

Hi Alex

Try:

=SUMIF(A2:A100, 25)

to find the sum of all 25's in the range.

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Graham Haughs]

Hi Alex,

=SUMIF(A1:A50,B1)
Where B1 is the value you want summed and A1:A50 the column range.

Kind regards,
Graham Haughs
Turriff, Scotland

 

[Alex Kachanov]

None of your answers helps me...
I need more general solution.
Imagine I have following data: 1 4 2 3 4 3 5 4 1. So sum of repeating values
will be 4+4+4+3+3+1+1. And also I get my data by some calculation, so I
don't know what to use in SUMIF.
How can I do that?
Thanks.

 

[Leo Heuser]

Instead try:

=SUMPRODUCT((COUNTIF(A1:A11,A1:A11)>1)*A1:A11)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

 

[Alex Kachanov]

=SUMPRODUCT((COUNTIF(A1:A11,A1:A11)>1)*A1:A11)

O, really cool and beautiful!
That's what I want!

________________
Alexander Kachanov aka Alex29
nntp<>alex29.dp.ua
ICQ# 14840340

 

[Leo Heuser]

You're welcome.
Thanks for the feedback!

LeoH

O, really cool and beautiful!
That's what I want!

________________
Alexander Kachanov aka Alex29
nntp<>alex29.dp.ua
ICQ# 14840340