To PECOFLYER
Thankyou for your interest in my post. Sorry about the lack of clarity in the question. I meant in the range A22:Y22 return the number of cells with a value greater than the value in E22.
The problem has now been solved but thanks anyway.