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