Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible?
Is it possible to have an equation that determines a COUNTIF for a month? ie.
if I have the dates 12/5/2005 and 11/21/2005, it would count 1 for November, and 2 for December. Or is even something that works to the effect of =(COUNTIF B:B, "<9/31/2005 AND 9/1/2005" possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible?
Hi fireofeve,
It looks like you're after a count for September. In that case, try: =(COUNTIF B:B, ""&DATEVALUE("9/1/2005")-1)-(COUNTIF B:B, ""&DATEVALUE("9/31/2005")) or =(COUNTIF B:B, ""&DATEVALUE("8/31/2005"))-(COUNTIF B:B, ""&DATEVALUE("9/31/2005")) Cheers -- macropod [MVP - Microsoft Word] "fireofeve" wrote in message ... Is it possible to have an equation that determines a COUNTIF for a month? ie. if I have the dates 12/5/2005 and 11/21/2005, it would count 1 for November, and 2 for December. Or is even something that works to the effect of =(COUNTIF B:B, "<9/31/2005 AND 9/1/2005" possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possible?
=SUMPRODUCT(--(B1:B1000<=--"2005-09-31"),--(B1:B1000=--"2005-09-01"))
or how about =SUMPRODUCT(--(MONTH(B1:B1000)=9)) Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "fireofeve" wrote in message ... Is it possible to have an equation that determines a COUNTIF for a month? ie. if I have the dates 12/5/2005 and 11/21/2005, it would count 1 for November, and 2 for December. Or is even something that works to the effect of =(COUNTIF B:B, "<9/31/2005 AND 9/1/2005" possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possib
Thank you!
"Bob Phillips" wrote: =SUMPRODUCT(--(B1:B1000<=--"2005-09-31"),--(B1:B1000=--"2005-09-01")) or how about =SUMPRODUCT(--(MONTH(B1:B1000)=9)) Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "fireofeve" wrote in message ... Is it possible to have an equation that determines a COUNTIF for a month? ie. if I have the dates 12/5/2005 and 11/21/2005, it would count 1 for November, and 2 for December. Or is even something that works to the effect of =(COUNTIF B:B, "<9/31/2005 AND 9/1/2005" possible? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the equation: =COUNTIF B:B, <9/31/2005 AND 9/1/2005 possib
thank you!
"macropod" wrote: Hi fireofeve, It looks like you're after a count for September. In that case, try: =(COUNTIF B:B, ""&DATEVALUE("9/1/2005")-1)-(COUNTIF B:B, ""&DATEVALUE("9/31/2005")) or =(COUNTIF B:B, ""&DATEVALUE("8/31/2005"))-(COUNTIF B:B, ""&DATEVALUE("9/31/2005")) Cheers -- macropod [MVP - Microsoft Word] "fireofeve" wrote in message ... Is it possible to have an equation that determines a COUNTIF for a month? ie. if I have the dates 12/5/2005 and 11/21/2005, it would count 1 for November, and 2 for December. Or is even something that works to the effect of =(COUNTIF B:B, "<9/31/2005 AND 9/1/2005" possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|