Help on Countifs with a less than or Equal to criterea

[taubeam]

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 it and that number is less than or equal to Mapping!AI$1

Every thing I've tried hasn't worked.

Please and thank you

 

[Asala42]

Your formula appears structurally correct.
What's wrong with the output specifically? Is the formula resulting with an error? A count that's too high? Too low?

Depending on your specific data, the null data in 'Rep Quotas'!$BQ:$BQ may be messing with your expected results. I'd expect your formula to treat blank cells in that column as if they were 0, so that may be adding to your count unintentionally.

HTH

 

[taubeam]

Your formula appears structurally correct.
What's wrong with the output specifically? Is the formula resulting with an error? A count that's too high? Too low?

Depending on your specific data, the null data in 'Rep Quotas'!$BQ:$BQ may be messing with your expected results. I'd expect your formula to treat blank cells in that column as if they were 0, so that may be adding to your count unintentionally.

HTH

Thanks, for confirming. I'm thinking it's the format of the "numbers" I'm translating a date to a number for the month but I didn't make it a text.