Count Problem between dates

[Frick]

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.

[Bernard Liengme]

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


"Frick" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Peo Sjoblom]

=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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Frick]

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:C31>0)) but that only returned 0 when with data entered shoud have returned a count value of 4.

Any other ideas?

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Frick" <[email protected]> wrote in
message news:[email protected]...
>
> 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:C31>0)) 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
>