Hi,
I'm working on a formula which has to count which values in a range are smaller than 85. However, it always returns 0 and I can't seem to find out why.
Code
=COUNTIF(INDEX(IFERROR(VALUE(OFFSET('[MR Data.xlsx]Throughput OUT'!$C$1:$BW$31,MATCH("Throughput at "&J16&" (time)",'[MR Data.xlsx]Throughput OUT'!$B:$B,0)+1,0)),0),,MATCH($B16,'[MR Data.xlsx]Throughput OUT'!$C$12:$BW$12,0)),"<85")
The range that I get is:
Code
{0;0;99.2003106902189;99.3237176764998;98.1927164523149;98.5735689912153;99.392772040846;0;0;98.6325134692947;98.7672864746517;97.6097208803074;99.3127577005428;99.5343545290336;0;0;91.8404980728644;98.9542351167087;97.764265176103;97.2293725600979;98.7022097400667;0;0;98.5996310616598;99.4744845394647;83.1670428689839;97.8408794715537;98.8089104637371;0;0;0}
So there should be values which are smaller than 85. Why do I get 0 results?