Thanks:  0
Likes:  0

Thread: Counting without double counting

1. I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks

2. On 2002-03-15 06:56, Anonymous wrote:
I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks
=IF(LEN(A1:A10),SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)))

where A1:A10 houses the target numbers.

3. 1. If you want to specify the specific range
for the data (revise to fit your info)

=SUMPRODUCT(1/COUNTIF(A1:A6,A1:A6))

2. If you want to specify a range
that may include blank cells, use
Array formulas such as the following:

a) =SUM(IF(LEN(rData),1/COUNTIF(rData,rData)))

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

Enter the Array formulas with Ctrl-Shift-Enter (CSE)

4. On 2002-03-15 06:56, Anonymous wrote:
I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks
With your values in A1:A6 use...

=COUNT(IF(FREQUENCY(A1:A6,A1:A6),1))

User Tag List

Posting Permissions

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