Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
Any one could help me pls.
I have a spreadsheet that I want to count records like this. A B Start Retile 1/1/2006 1/2/2007 1/1/2006 20/4/2007 15/6/2006 10/4/2007 I would like to count start is between 1/1/2006 to 31/3/2006 and retile is between 1/1/2007 to 31/3/2007 Thank you so much kim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
=SUMPRODUCT(--(A2:A4=DATEVALUE("1/1/2006")),--(A2:A4<=DATEVALUE("31/3/2006")),--(B2:B4=DATEVALUE("1/1/2007")),--(B2:B4<=DATEVALUE("31/3/2007")))
Adjust ranges to real situation! Regards, Stefi €˛Sumeth€¯ ezt Ć*rta: Any one could help me pls. I have a spreadsheet that I want to count records like this. A B Start Retile 1/1/2006 1/2/2007 1/1/2006 20/4/2007 15/6/2006 10/4/2007 I would like to count start is between 1/1/2006 to 31/3/2006 and retile is between 1/1/2007 to 31/3/2007 Thank you so much kim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
Thanks Stefi,
I try to use that formula and delete "--" but the result is zero. I don't know why? can you tell me more about this. Thanks so much |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
Don't delete "--", its an important part of the formula: forces to convert
logical values to numbers! Stefi €˛Sumeth€¯ ezt Ć*rta: Thanks Stefi, I try to use that formula and delete "--" but the result is zero. I don't know why? can you tell me more about this. Thanks so much |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
Hi, Stefi
Thank you so much, That's ok. It can work now. so great! c.sumeth |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to count 2 date columns conditions.
You are welcome! Thanks for the feedback!
Stefi €˛Sumeth€¯ ezt Ć*rta: Hi, Stefi Thank you so much, That's ok. It can work now. so great! c.sumeth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count pieces of records meet conditions in different columns | Excel Worksheet Functions | |||
Count with 2 conditions, second one OR | Excel Worksheet Functions | |||
count all the columns in a range with certain conditions | Excel Discussion (Misc queries) | |||
Count with 2 conditions? | Excel Worksheet Functions | |||
count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions |