View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Counting contents in aray

=SUM(COUNTIF(A1:C10,{"A","L"}))

--
__________________________________
HTH

Bob

"jpreman" wrote in message
...
Thanks for reading this post.

One in each cell, there are several alphabets in a range of cells (eg. A1
:C10). I would like to know the combined count of alphabets "A" and "L".
How
can I achieve this?

Tks

Preman