Forum Discussion
Jessjess1150
Sep 29, 2021Copper Contributor
Data Sheet - Pivot Table -One Result Return
Good afternoon!
I have a data file where I would like to be able to return one result when there are multiple duplicate entries for that same results so when combined, it does not add up the total but instead show that ONE result.
For example, I may have one estimate budget that contains multiple entries with the same repeated number. When view within a pivot table, it adds up the total to give me an inflated number instead to give me simply the estimate number.
- If it solves your problem, please flag it as solved.
Remember that hitting the like button is less costly than buying me a coffee. 😉
5 Replies
- Juliano-PetrukioBronze Contributor
If you are using Office 365
=SUM(UNIQUE(H2:H13))
For older Excel version
=SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13),H2:H13)
- Jessjess1150Copper ContributorHello - thanks so much for your help!
It still returns duplicates entries.- Juliano-PetrukioBronze Contributor