View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Darryl
 
Posts: n/a
Default countif counting properties

Hey.
I am using countif to total the number of H's in a group of cells, everytime
it counts a H it counts a whole number.
I need to use a formula where instead of counting a whole number it counts
up in 0.5 per H.
Any suggestions?
Your help would be much appreciated.
Thanks
Darryl