countif function for the secound question
i have an issue with the second question
every time i was trying to use count if function to determine which criteria has the most frequency, i got a zero.
=countif(E6:E174,j5) which j5= 1534-2034
so what is the wrong i was doing ?
1 answers ( 0 marked as helpful)
Hello,
I'm not sure if Excel is able to find the content of J5 in the range E6:E174. To check if that's true please create a formula that goes like this =J5=
and then point to a cell in the range E6:E174 selecting it.
If the output is FALSE, then this means that J5 is different than the cells equal to it in the range E6:E174. Could be formatting or some other reason.
Hope this helps!
Best,
Ned