Count number of instances
 

Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce

Count number of instances
 

Do you mean a unique count..=COUNT() will give you a total count of numeric
values (including date, time, numbers etc; ).

Why dont you post few samples...

"Curtis" wrote:

Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce

Count number of instances
 

Yes sorry unique count.

If I have Products in column b

apples
apples
peach
grape
lemon

I want to count the number of unique products as in this case the result
would be 4
--
ce


"Jackpot" wrote:

Do you mean a unique count..=COUNT() will give you a total count of numeric
values (including date, time, numbers etc; ).

Why dont you post few samples...

"Curtis" wrote:

Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce

Count number of instances
 

Try the below.

=SUMPRODUCT((B1:B20<"")/COUNTIF(B1:B20,B1:B20&""))


"Curtis" wrote:

Yes sorry unique count.

If I have Products in column b

apples
apples
peach
grape
lemon

I want to count the number of unique products as in this case the result
would be 4
--
ce


"Jackpot" wrote:

Do you mean a unique count..=COUNT() will give you a total count of numeric
values (including date, time, numbers etc; ).

Why dont you post few samples...

"Curtis" wrote:

Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce

Count number of instances
 

If you wanted to count the number of unique entries in that range, you could use
a formula like:

=sumproduct((a1:a10<"")/countif(a1:a10,a1:a10&""))
(you can only use the entire column in xl2007)

Curtis wrote:

Need a formaula to look at an entire column and count the number of
different times (say date of product)

Thanks
--
ce

--

Dave Peterson