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: