+1 vote
in General IT Tips by (73.8k points)
I have some data in an Excel sheet. I want to find the number of columns with a value greater than some given value for each row. Which Excel functions should I use for it?

1 Answer

+3 votes
by (348k points)
selected by
Best answer

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:

Excel number of columns with value greater than some value