COUNTIF - USING WITH TIME VALUE RANGES
I would like to count an entry in a different worksheet but in the same
workbook if the entry falls between certain hours. Here is the formual I am using: =COUNTIF(Tickets!G:G,"<17:00:11:59") where as "Tickets" is the other worksheet and I would like to count the entries that fall between 11:59 and 17:00. Using this formula the result shows as "0" which is not correct. Please advise what changes need to be made to the formula for this to work properly. |
COUNTIF - USING WITH TIME VALUE RANGES
That's the wrong syntax for COUNTIF. What you could do is a 2-step subtraction:
=COUNTIF(Tickets!G:G,"11:59")-COUNTIF(Tickets!G:G,"=17:00") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Kazman" wrote: I would like to count an entry in a different worksheet but in the same workbook if the entry falls between certain hours. Here is the formual I am using: =COUNTIF(Tickets!G:G,"<17:00:11:59") where as "Tickets" is the other worksheet and I would like to count the entries that fall between 11:59 and 17:00. Using this formula the result shows as "0" which is not correct. Please advise what changes need to be made to the formula for this to work properly. |
COUNTIF - USING WITH TIME VALUE RANGES
Kazman
Check your previous post... If this post helps click Yes --------------- Jacob Skaria "Kazman" wrote: I would like to count an entry in a different worksheet but in the same workbook if the entry falls between certain hours. Here is the formual I am using: =COUNTIF(Tickets!G:G,"<17:00:11:59") where as "Tickets" is the other worksheet and I would like to count the entries that fall between 11:59 and 17:00. Using this formula the result shows as "0" which is not correct. Please advise what changes need to be made to the formula for this to work properly. |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com