Microsoft Office Tutorials and References
In Depth Information
Going for the Count
Here’s how to use the LARGE or SMALL function:
1. Enter a list of numerical values.
2. Position the cursor in the cell where you want the result to appear.
3. Enter either =LARGE( or =SMALL( to start the function.
4. Drag the pointer over the list, or enter the address of the range.
5. Enter a comma (,).
6. Enter a number indicating the position to return.
7. Enter a ) and press the Enter key.
Use LARGE to find a value’s position relative to the highest value. Use SMALL
to find a value’s position relative to the smallest value.
Going for the Count
The COUNT and COUNTIF functions return, well, a count. What else could it
be with a name like that?
COUNT
COUNT is straightforward. It counts how many items are in a range of values.
There is a catch, though: Only numeric values and dates are counted. Text
values are not counted, nor are blank cells.
COUNTA works the same as COUNT, but it counts all cells that are not empty,
including text cells.
To use the COUNT function:
1. Enter a list of numerical values.
2. Position the cursor in the cell where you want the result to appear.
3. Enter =COUNT( to start the function.
4. Drag the pointer over the list, or enter the address of the range.
5. Enter a ) and press the Enter key.
Search JabSto ::




Custom Search