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
Abiola1's avatar
Abiola1
MVP
Feb 06, 2020
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)
DKGURUNG's avatar
DKGURUNG
Copper Contributor
Feb 06, 2020
Thank you for your help.

Resources