find repeating values

  • Thread starter Thread starter Alex Kachanov
  • Start date Start date
A

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
 
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.
 
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
 
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.
 
Instead try:

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

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
=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
 
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
Click to expand...
 
Back
Top