How to use the 【 Countif Function 】 in Excel

How to use the 【 Countif Function 】 in Excel

How to count the number of cells

In business, we often need to count something.

Using Countif Function in Excel can help you work more efficiency.

This article describes the basic usage of countif function.

Countif Function

Sample data

The following Excel sheet was prepared.

This data is contained some information about people and their address.

Now, the purpose is to count the number of address.

In other words, to fill the cells of G3:G6.

What is Countif?

Let me explain about Countif Function in Excel.

It can counts a particular character within the range.

There are two arguments: the range and the search target.

And the return value is the count.

Calculations

Let’s try using Countif Function.

The following function is written in cell G3.

=countif($D$3:$D$12,F3)

Use absolute reference for the search range.

When I pressed Enter key, the number of “Tokyo” was displayed.

We can also display other addresses by using autofill.

The purpose of this article was compleated.

Conclusion

In this article, How to use Countif Function was introdused.

  • Use function when you count some number
  • Countif has two arguments
  • The range is used absolute reference
(Visited 4 times, 1 visits today)

コメントを残す

メールアドレスが公開されることはありません。 が付いている欄は必須項目です