![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Statistical > COUNTA |
COUNTA(value1, value2 [, value3] [,...]) |
| Returns the number of non blank cells in a list or cell range. |
| value1 | The first value. | |
| value2 | The second value. | |
| value3 | The third optional value. |
| REMARKS |
| This is identical to the COUNT() function except that text, logical values and errors are included. | ||
| Arguments that are empty cells are ignored. See Example 7. | ||
| Any arguments that are text or blank strings will evaluate to 1. | ||
| Any arguments that contains True will evaluate to 1. | ||
| Any arguments that contains False will evaluate to 0. | ||
| You can have a maximum of 30 arguments. |
| EXAMPLES |
|
| Functions - C | Index - C | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |