Hello
I am trying to write a countifs where one criteria is a less than or equal to a number.
=COUNTIFS('Rep Quotas'!$G:$G,Mapping!$AA4,'Rep Quotas'!$H:$H,Mapping!$Z4,'Rep Quotas'!$D:$D,"Field",'Rep Quotas'!$BQ:$BQ,"<="&Mapping!AI$1)
Where: 'Rep Quotas'$BQ:$BQ can be null or have a number in...