Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting different dates
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting different dates
Hi Patel
Try dates: A1:A20 =SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&"")) Regards, Pedro J. 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting different dates
Maybe something like this:
=SUM(IF(FREQUENCY(A1:A7,A1:A7)0,1)) HTH, Paul -- "AJ Patel" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting different dates
thanks
"Infinitogool" wrote: Hi Patel Try dates: A1:A20 =SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&"")) Regards, Pedro J. 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting different dates
thanks
"PCLIVE" wrote: Maybe something like this: =SUM(IF(FREQUENCY(A1:A7,A1:A7)0,1)) HTH, Paul -- "AJ Patel" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with counting between dates | Excel Discussion (Misc queries) | |||
Counting Dates | Excel Discussion (Misc queries) | |||
counting occasions dates occur between 2 dates | New Users to Excel | |||
Counting dates, within a list of dates | Excel Worksheet Functions | |||
counting dates | Excel Worksheet Functions |