Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if date is between two dates and value in another column equ | Excel Worksheet Functions | |||
Count cells with dates | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Problem with dates | Excel Worksheet Functions | |||
count the no.of records between two dates | Excel Worksheet Functions |