=COUNT(CELL RANGE)

or

= COUNTA(CELL RANGE)

"stratis" wrote:

I have a long 16000 lines sheeet that contains the checking per day per
Section.
ie
Jan 1, Sales, Mr X
Jan 1, Sales, Mr Y
Jan 1, Marketing, Mr Z
Jan 2, Sales, Mr X
Jan 2, Marketing, Mr Z

I want to add the functiion like COunt, or dcount
Jan 1, Sales 2, people
Jan1, Marketing, 1 person
Jan 2, Sales, 1 Person
etc...