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.