View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TommyB TommyB is offline
external usenet poster
 
Posts: 12
Default Count only Letters in cells that contain both letters and numbers

Hello to all.

I have a Column that has cells with both numbers and letters, like this:
W 6-2
L 3-7
W 11-6
W 1-0

I want to add up the number of W's that appear in this range. Don't seem to
be able to figure it out. Can anyone help?
Thanks!

--
TommyB