Forum Discussion

DKGURUNG's avatar
DKGURUNG
Copper Contributor
Feb 06, 2020

How to insert two (< = ) operators in a formula/criteria?

=COUNTIFS('Data 4'!$Q:$Q,$A29,'Data 4'!$O:$O,'Count visits'!G$26,'Data 4'!$I:$I,"<1:00:00")   Help needed to modify the formula so the criteria also includes (=1:00:00) at the end. Thank you in ad...
excel
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Feb 06, 2020
no need for two arguments. <= will do the job
  • DKGURUNG's avatar
    DKGURUNG
    Copper Contributor
    Feb 06, 2020
    Thank you for your assistance.
  • DKGURUNG's avatar
    DKGURUNG
    Copper Contributor
    Feb 06, 2020
    =COUNTIFS('Data 4!$Q:$Q,$A29,'Data 4'!$O:$O,'Count visits'!G$26,'Data 4'!$I:$I,"=<1:00:00")

    wondering why this is not working for me!!
    Thank you.
    • DKGURUNG's avatar
      DKGURUNG
      Copper Contributor
      Feb 10, 2020

      =COUNTIFS('Data new'!$Q:$Q,$A27,'Data new'!$O:$O,J$26,'Data new'!$I:$I,{"<1:30","=1:30"})

       

      This one is working for me.  Had to use {} probably because the value is time measurement.

       

Resources