# find repeating values

A

#### Alex Kachanov

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

________________
Alexander Kachanov aka Alex29
ICQ# 14840340

L

#### 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

G

#### 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

A

#### Alex Kachanov

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.

L

#### Leo Heuser

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

--
Best Regards
Leo Heuser
MVP Excel

A

#### 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

L

#### Leo Heuser

You're welcome.
Thanks for the feedback!

LeoH

Alex Kachanov said:
O, really cool and beautiful!
That's what I want!

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