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
|