counting different dates

[AJ Patel]

Hi all,
This question may have been answered before but I did not see it going
through many of the posts. Below is what I am looking for
I have a list of returned products column A is the date product is returned
the other columns data referring to the return. I want to keep a running
total of the # of dates I received returns on. For Example if I have the
following Dates:

8/1/08
8/1/08
8/2/08
8/3/08
8/4/08
8/4/08
8/5/08

I need the running total to say that there are 5 days, basically the formula
should count each date only once despite having multiple entries on the same
date.

 

[Infinitogool]

Hi Patel

Try
dates: A1:A20
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))

Regards,
Pedro J.

 

[PCLIVE]

Maybe something like this:

=SUM(IF(FREQUENCY(A1:A7,A1:A7)>0,1))

HTH,
Paul

 

[AJ Patel]

thanks

Hi Patel

Try
dates: A1:A20
=SUMPRODUCT((A1:A20<>"")/COUNTIF(A1:A20,A1:A20&""))

Regards,
Pedro J.

 

[AJ Patel]

thanks

Maybe something like this:

=SUM(IF(FREQUENCY(A1:A7,A1:A7)>0,1))

HTH,
Paul