View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default Count if begins with AAA

You can use a CountIf formul for that. This will count all cells
within row 11 that starts with "www".
=COUNTIF(11:11,"www*")

If you want to do a column, then:
=COUNTIF(A:A,"www*")

Neall wrote:
I am wondering if I can this

search a row and return a numeric representation of cells in that row that
start with the letters "www"

Thanks in advance
--
Neall