COUNTIF(range, criteria)The COUNTIF function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
•range Required. One or more cells to count, including numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
•criteria Required. A number, expression, cell reference, or text string that defines which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32".