You can use the Excel function COUNTIF() for it.
Suppose you have data from columns A to E, for row 1, you can write the following function to count the number of columns with a value > 0.5.
=COUNTIF(A1:E1, ">0.5")
Here is a screenshot of an example: