Problem with excel..?

Question

in an excel spreadsheet, I have a column(V4:V57) that all contains a single number (1 - 7). In a different cell, I want to have a formula that calculates how many cells in the above column are greater than the number 2.

Answer 1

You can use COUNTIF. I think this is the formula, or atleast something close to it:

=COUNTIF(V4:V57,">2")

Answer 2

Use the following formula.

=COUNTIF(v4:v57;">2")