Question #11650426
Countif(Sheet1!$E:$E, "<4000")?
Countif(Sheet1!$E:$E, "<4000") For some reason this does not work. Whats the proper syntax to count the values smaller than a certain number because when I try just for 4000 LCountif(Sheet1!$E:$E, "4000") it works, but not when I want to count numbers smaller than that number. Additional Details This is in Microsoft Excel. I just do not know what I am doing wrong the countif for smaller than a number does not work. the range is not the problem because when I do Countif(Sheet1!$E:$E, "4000") it works perfectly as it should. I just need to count when it is smaller than 4000. Even when I try Countif(Sheet1!$E:$E, "2000") it works as well. But it does not work when I try Countif(Sheet1!$E:$E, "
TELL US , if you have any answer
Sponsored ads
TAG cloud
Countif Sheet1 E E quot lt 4000 quot Countif Sheet1 E E quot lt 4000 quot reason proper syntax values smaller certain number because LCountif Sheet1 E E quot 4000 quot works numbers smaller number Additional Details
This Microsoft Excel countif smaller number problem because Countif Sheet1 E E quot 4000 quot perfectly should smaller Countif Sheet1 E E quot 2000 quot Countif Sheet1 E E quot
0