Ads

Monday, 16 January 2017

Countif()

This formula will help you to Count according to condition.

=Countif(range, criteria)

Range= Area for which count is to be performed.

Criteria= What is required to count.

For ex: There is a messed data of sales.
You want total count of a particular deal. This is where you can use this formula.

No comments:

Post a Comment