Count Function in Excel - Office Corner

new dictionary define in office corner combin combination

Software Articles Templates Dictionary Home

COUNT function

When we use basic COUNT formulas as =COUNT(RANGE OF CELLS) you will get a number of cells with number only values, for example we have different data types in cells from A1 to A10. When we use COUNT formula at A11, we will get result 5 as a number of cells that has any number only data. But when we would type =COUNT(A1:A10, com) we will get our 5 number only value plus one for 'com' word we typed, so the new result is 6.

In COUNT formula you don't have to type exact keyword, for example if we use =COUNT(A1:A10, makeme) the result will be 6, because excel doesn't count spaces.

COUNT formula can be modified to: COUNTIF, COUNTA, COUNTBLANK. For more information about this formulas choose one of them.

COUNT function Exercises

1. Type different data type values from digits, text, marks of punctuation and mixing it all together in range cells from A1 to A15. Use =COUNT(A1:A15).

2. Use the sama data you typed in A1 to A15 cells range and use =COUNT(A1:A10). Do you get the same result?

3. Try to change =COUNT(A1:A15) for =COUNT(A1:A15, different_data) where different_data is exact non only number value you typed in A1 to A15.

Check all Beginner's Tips
Learn how to use Excel functions and formulas
in three steps of difficulty >>