View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Can i count how many letters A from cell e10 to sell h10 ?

Try: =COUNTIF(E10:H10,"A")

For info, the expression is not case sensitive
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"waleed" wrote:
Can i count how many letters A from cell e10 to sell h10 ?

i need to count all value countin letter a .
I have attendence sheet and I alwayes put letter p for present student and
letter a for student who is absent . So in the total list of absenties i
have to count how many "A" place of "p"