counting entries between two dates?
Hi I am tring to count how many entries I have between two dates. I have
been trying to use the countif function and can't get greater or less thans to work with it. My dates are in cells c88 (lowest to count) and c89 (highest to count). The data is in column P Also, I will need to do the same counting of dates but in two columns instead after this is figured out. =COUNTIF(P5:P86,C88) is what I have and of course its not right at all. TIA Todd |
Hi
try: =COUNTIF(P5:P86,"=" & C88)-COUNTIF(P5:P86,"" & C89) -- Regards Frank Kabel Frankfurt, Germany Todd wrote: Hi I am tring to count how many entries I have between two dates. I have been trying to use the countif function and can't get greater or less thans to work with it. My dates are in cells c88 (lowest to count) and c89 (highest to count). The data is in column P Also, I will need to do the same counting of dates but in two columns instead after this is figured out. =COUNTIF(P5:P86,C88) is what I have and of course its not right at all. TIA Todd |
Try the following formula... =SUMPRODUCT(--(P5:P86=C88),--(P5:P86<=C89)) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
Thanks its not quite right. Both formulas are adding all the dates in the
column but not subtracting the dates over the range. It looks right to me and I have tried typing the dates into the formula but haven't got it yet. Any ideas? Todd "Domenic" wrote: Try the following formula... =SUMPRODUCT(--(P5:P86=C88),--(P5:P86<=C89)) Hope this helps! -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
Hi
what is the formula you have tried? Both formulas should work -- Regards Frank Kabel Frankfurt, Germany Todd wrote: Thanks its not quite right. Both formulas are adding all the dates in the column but not subtracting the dates over the range. It looks right to me and I have tried typing the dates into the formula but haven't got it yet. Any ideas? Todd "Domenic" wrote: Try the following formula... =SUMPRODUCT(--(P5:P86=C88),--(P5:P86<=C89)) Hope this helps! -- Domenic -------------------------------------------------------------------- ---- Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
Inclusive between count: =COUNTIF($P$5:$P$86,"="&C88)-COUNTIF($P$5:$P$86,""&C89) Todd Wrote: Hi I am tring to count how many entries I have between two dates. I have been trying to use the countif function and can't get greater or less thans to work with it. My dates are in cells c88 (lowest to count) and c89 (highest to count). The data is in column P Also, I will need to do the same counting of dates but in two columns instead after this is figured out. =COUNTIF(P5:P86,C88) is what I have and of course its not right at all. TIA Todd -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
Thanks, Here is the formula I am trying.
=COUNTIF($P$11:$P$40,"="&9/1/4)-COUNTIF($P$11:$P$40,"<"&9/30/4) "Frank Kabel" wrote: Hi what is the formula you have tried? Both formulas should work -- Regards Frank Kabel Frankfurt, Germany Todd wrote: Thanks its not quite right. Both formulas are adding all the dates in the column but not subtracting the dates over the range. It looks right to me and I have tried typing the dates into the formula but haven't got it yet. Any ideas? Todd "Domenic" wrote: Try the following formula... =SUMPRODUCT(--(P5:P86=C88),--(P5:P86<=C89)) Hope this helps! -- Domenic -------------------------------------------------------------------- ---- Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
=COUNTIF($P$11:$P$40,"=9/1/04")-COUNTIF($P$11:$P$40,"9/30/04") Todd Wrote: Thanks, Here is the formula I am trying. =COUNTIF($P$11:$P$40,"="&9/1/4)-COUNTIF($P$11:$P$40,"<"&9/30/4) [...] -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=274301 |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com