I am using the following formaula to try and find the max number when a certain condition is met.
=MAX(IF($L$14:$L$194=F5,$J$14:$J$194,0))

However it seems that because the number is negative it defaults to 0, can anyone tell me why this is? and also help with a solution.

Thanks