Count Problem between dates
 

D7=Start Date F7=End Date

B13:B31 Data Dates
C13:C31 Data

I need a formula that will count the number of entries in range
C13:C31 that are between the dates in D7 and F7.

Thanks for your help.


--
Frick
------------------------------------------------------------------------
Frick's Profile: http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772

Count Problem between dates
 

Try =SUMPRODUCT(--(D13:D19D7),--(D13:D19<F7))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"Frick" wrote in message
...

D7=Start Date F7=End Date

B13:B31 Data Dates
C13:C31 Data

I need a formula that will count the number of entries in range
C13:C31 that are between the dates in D7 and F7.

Thanks for your help.


--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772

Count Problem between dates
 

=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7))

will count dates in B13:B31 that are bewteen D7 and F7
however what is the criteria for C13:C31? If not empty is the criteria

=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),(C13:C31<""))

otherwise post back with criteria


--

Regards,

Peo Sjoblom


"Frick" wrote in message
...

D7=Start Date F7=End Date

B13:B31 Data Dates
C13:C31 Data

I need a formula that will count the number of entries in range
C13:C31 that are between the dates in D7 and F7.

Thanks for your help.


--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772

Count Problem between dates
 

Column B has Dates in no specific order. Column C has either a number
greater then 1 or 0. I tried Count but because every cell has a
formula that either retuns a number or 0, the result was it counted
every cell. I can't use the count for Col B because some dates entered
in B are for data in Col's D through I.

I tried the formula
=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),(C13:C310)) but that only
returned 0 when with data entered shoud have returned a count value of
4.

Any other ideas?


--
Frick
------------------------------------------------------------------------
Frick's Profile: http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772

Count Problem between dates
 

=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),--(C13:C310))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Frick" wrote in
message ...

Column B has Dates in no specific order. Column C has either a number
greater then 1 or 0. I tried Count but because every cell has a
formula that either retuns a number or 0, the result was it counted
every cell. I can't use the count for Col B because some dates entered
in B are for data in Col's D through I.

I tried the formula
=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),(C13:C310)) but that only
returned 0 when with data entered shoud have returned a count value of
4.

Any other ideas?


--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772