How to count the number of cells within a range (Excel)

November 18, 2009 · Posted in Ms Office 

How do I count the frequency of a cell range with a simplest way?

table1

Counts the number of cells within a range

The simplest ways to count the frequency of cell range is to use COUNTIF formula.

COUNTIF (range,criteria)

Range is the range of cells from which you want to count cells.

Criteria are the criteria in the form of a number, expression, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as “Banana”, “Mango”, or “Apple” / B2.

excel1

Enter the following formula:-

COUNTIF(B2:B15,”Apple”)

After entering the formula, you will get the result of 4 which means that Apple taken 4 days in this example.

Just try to play around this formula, this formula can do more task than that example that i show. :-)

Tags: no tags

Comments

Leave a Reply