Forum Discussion
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 advance.
6 Replies
- no need for two arguments. <= will do the job
- Thank you for your assistance.
- =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.=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.
- If the criteria2 is a value you typed in, you don't need to surround it with double quotation.
<=1000 (for example as your criteria2)- Thank you for your help.
