Monday, May 16, 2011

COUNT




What Does It Do ?
This function counts the number of numeric entries in a list. It will ignore blanks, text and errors.

Syntax
=COUNT(Range1,Range2,Range3... through to Range30)

Formatting
No special formatting is needed.

Example
The following table was used by a builders merchant to calculate the number of sales for various products in each month.


Twitter Bird Gadget