Forum Discussion
Solved
COUNTIFS LESS THAN YEAR 2017 does not work when I use "<"&2017
Hello, My COUNTIFS less than year 2017 formula does not work, please see below and in attached excel the cell highlighted in yellow. =COUNTIFS(Indirect!AI:AI,"Agent",Indirect!AQ:AQ,"<"&2017,I...
Nope, I didn't re-format the data.
You may try alternative formula
=SUMPRODUCT( (Indirect!AI:AI="Agent")*(Indirect!AQ:AQ<"2017")*(Indirect!AR:AR="0"))it's here
plus please check if in main file you have texts or numbers like
Thank you! SergeiBaklan Can I ask did you apply any formatting to any of the cells used in the formula? As when I copy your formula across into my latest version excel I still get 0 😞
Nope, I didn't re-format the data.
You may try alternative formula
=SUMPRODUCT( (Indirect!AI:AI="Agent")*(Indirect!AQ:AQ<"2017")*(Indirect!AR:AR="0"))it's here
plus please check if in main file you have texts or numbers like
- Thank you! Much appreciated!!!
JennyHoA20181 , you are welcome