COUNTIF(A1:A100,"P")

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Shakir" wrote in message
...
for instance i am managing attendance, and p represents a present can i
have
xcel count number of P's or A's that is absences etc. automatically like
the
"sum" function?