![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Excel > Functions > Statistical > COUNT |
COUNT(value1 [,value2] [,...]) |
| Returns the number of numeric values in a list or cell range. |
| value1 | The first value. | |
| value2 | The second optional value. |
| REMARKS |
| This function includes hidden rows. | ||
| Arguments that are numbers, dates, or text representations of numbers are counted. | ||
| Arguments that are text, logical values or errors are ignored. | ||
| Arguments that are empty cells are ignored. See Example 5. | ||
| If an argument is an array or reference, only numbers in that array or reference are counted. See Example 11. | ||
| Use this function to get the number of entries in a number field in a range (or array) of numbers. | ||
| Dates and formulas that evaluate to numbers will be included. | ||
| You can have a maximum of 30 arguments. | ||
| If you do not want to count any arguments that are text, logical values or errors you can use the COUNTA() function. | ||
| FORMATCOUNT() - Returns the number of cells that have a particular format. | ||
| Example 1 - | ||
| Example 2 - | ||
| Example 3 - | ||
| Example 4 - | ||
| Example 5 - | ||
| Example 6 - | ||
| Example 7 - | ||
| Example 8 - | ||
| Example 9 - | ||
| Example 10 - | ||
| Example 11 - |
| EXAMPLES |
|
| Functions - C | Index - C | Office Online 2003 | Office Online 2007 |
| Copyright © 2010 Better Solutions Limited. All Rights Reserved. | Top |