# How to use SUM DISTINCT function in Pivot Table

This is a discussion on How to use SUM DISTINCT function in Pivot Table within the Excel Questions forums, part of the Question Forums category; Can I use Sum distinct function in pivot table. or How can i Add sum distinct as a function in ...

1. Can I use Sum distinct function in pivot table.

or How can i Add sum distinct as a function in excel

Akhilesh

2. How to Add unique values in excel

3. Hi,
What exactly do you want to do?. I suppose It has something to do with unique values but please give us some more information to answer your question.

4. assuming i have the following entries
4
5
6
7
4
5
6
etc
i want to add only unique values using
function sum

i believe by default it is not avialable
how can i write a function which adds only unique values while totalling

akhilesh

5. You probably mean: Count distinct...

Let A1:A10 house values with repeats.

Array-enter (using control+shift+enter)...

=SUM(IF(LEN(A1:A10),1/COUNTIF(A1:A10,A1:A10)))

6. No,

I want to sum distinct values and not just count them

I want the total displayed should be of only distinct values and not of all values

7. On 2002-12-09 06:59, akhil8377 wrote:
No,

I want to sum distinct values and not just count them

I want the total displayed should be of only distinct values and not of all values
As you wish...

Let A2:A8 house the sample you provided:

{4;5;6;7;4;5;6}

Use the following...

=SUM(UNIQUEVALUES(A2:A8))

to get the sum of the distinct numeric values.

http://longre.free.fr/english/index.html

8. Thanks, this is what i was looking for,

I hope this function will also work with piovot table calculated field

akhilesh

9. Hi,,

Though this is a good function for excel worksheets, as expected this is not working with calculated field of pivot tables..???

any suggestions

Akhilesh

10. Hi,
You should first adjust your sheet so that you have only unique values in it for you make a pivot table. To make the sheet only with unique value use the advanced filter from the Data, filter menu and click unique items.

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•