Count function to count a specific value.

Is there a way to use the count function to count a specific value.

Eg.
You're running a video store and want to find how many videos a member has borrowed using their member ID which is a number.
So you search for how many videos they have borrowed by typing in 1, 2, 3, etc. and then I want the count function to count how many times the number 1, 2, 3 (equivalent to the member ID) appears in the column.

Can anyone help?

=countif(range, memberID)

Thank You !

Worked like a charm.

You're welcome. Take a look at SUMIF as well.