Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frick
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frick
 
Posts: n/a
Default 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

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count if date is between two dates and value in another column equ mg_sv_r Excel Worksheet Functions 2 December 6th 05 03:31 PM
Count cells with dates Evgenia Excel Worksheet Functions 4 November 21st 05 01:21 PM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM
Problem with dates Emece Excel Worksheet Functions 7 December 22nd 04 07:47 PM
count the no.of records between two dates Sachin Pawar Excel Worksheet Functions 2 October 30th 04 01:19 PM


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"