Excel Formula question?

Question

I have a column consisting of the values 1,2,3,4,5,6,7,8,9,10.

I want to COUNT all of the values that are from 1-5 and place it in a cell. (Hence the cell would show "5", because there are 5 data points that have a 1,2,3,4, or 5).

How do I do this? Is it using the Countif function?

Answer 1

you are correct

it is the countif() you want

=COUNTIF(A:A,"<=5")

copy&paste that into column B

i used the full column, but you can limit it to a range like A1:A10 if you want to put the countif() anywhere in column A