Sep 29 2021 12:43 PM
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.
Sep 29 2021 12:55 PM - edited Sep 29 2021 12:59 PM
If you are using Office 365
=SUM(UNIQUE(H2:H13))
For older Excel version
=SUMPRODUCT(1/COUNTIF(A2:A13,A2:A13),H2:H13)
Sep 29 2021 12:59 PM
Sep 29 2021 01:03 PM
Find attached
Sep 29 2021 01:14 PM
SolutionSep 29 2021 01:16 PM
Sep 29 2021 01:14 PM
Solution