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
(e-mail address removed)
ICQ# 14840340
 
Ad

Advertisements

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

Followup to newsgroup only please.
 
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

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.
 
L

Leo Heuser

Instead try:

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

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top