COUNTIF function in Excel

Use

The COUNTIF function is used to count cells that meet a criterion; for example, to count, how many numbers of times, sale made to a particular customer.

Description

The COUNTIF function, categorized as a Statistical Function, can be used to counts cells with dates, text, and, numbers to match a criterion. For partial matching, it supports logical operator, such as (>,<,<>,=) and wildcards (*,?).

Syntax

=COUNTIF (range, criteria) where,

range – The range of cells that you want to count.

criteria – The criterion, which specifies what to count; e.g.  count cells if greater than etc.

Example

1. Type, =COUNTIF, select range, and criteria.

2. Result.

Use of the COUNTIF function

Count cells if greater than

Count cells if equal to

Count cells if end with

Count cells if contain negative numbers

Count cells if contain positive numbers

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved