View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Smith Karen Smith is offline
external usenet poster
 
Posts: 45
Default Counting Formula

I have a series of cells (B14..B17) that either say Yes or No. I want to
total up the Yes's to tell me how many of them there are. Can anyone tell me
a formula for that?