CODEWITHSUNDEEP
excelexcel-formulasumifsvba
Analystanand
Analystanand

Reputation: 35

Excel formula to sum if other column met some condition

I need a formula to sum if other column's all the unique values. They must be counted only once.

 Title               count     
 Chasing The Breeze    1
A Captivating Stare    3
A Captivating Stare    3
A Captivating Stare    3
A Captivating Stare    3
A Captivating Stare    3
Angelic                1

sum must be equal to =1+3+1=5

sum if other column

enter image description here

Upvotes: 1

Views: 100

Answers (2)

user4039065
user4039065

Reputation:

Try it as,

=SUMPRODUCT(B2:B8/COUNTIFS(A2:A8, A2:A8, B2:B8, B2:B8))

    sum_unique

Upvotes: 0

Thorarins
Thorarins

Reputation: 1904

lets say you have numbers in A1 to A10 you could do something like this

=SUMPRODUCT(1/COUNTIF(A1:A10;A1:A10&"");A1:A10)

Upvotes: 0

Related Questions