Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

COSH(number) [Category: Math]

Returns the hyperbolic cosine of a number.

COUNT(value1,value2, ...) [Category: Statistical]]

Counts the number of cells that contain numbers and numbers within the list

of arguments. Use COUNT to get the number of entries in a number ﬁ eld in a

range or array of numbers. Guru Tip: COUNT only counts numeric entries. If you

have to count cells in a range that might contain text or TRUE/FALSE values,

use COUNTA. If you have to count cells in a vertical range that might contains

blanks, use ROWS.

COUNTA(value1,value2, ...) [Category: Statistical]]

Counts the number of cells that are not empty and the values within the list of

arguments. Use COUNTA to count the number of cells that contain data in a

range or array.

COUNTBLANK(range) [Category: Information]

Counts empty cells in a speciﬁ ed range of cells. Guru Tip: Use =COUNTA(Rang

e)+COUNTBLANK(Range) to count all the cells in the range. You could also use

=ROWS(Range)*COLUMNS(Range). Both seem equally annoying.

COUNTIF(range,criteria) [Category: Math]

Counts the number of cells within a range that meet the given criteria. Guru Tip:

Along with SUMIF, added to Excel to prevent people from having to use array

formulas. The one drawback is that COUNTIF and SUMIF can only handle a

single criteria. Although most people don’t realize that the criteria in COUNTIF

can be dynamic as shown below. Also see pages 6 & 47.