Can anyone help please with this formula.
=COUNTIF(B208:AE208,"H")
This works fine to count the number of H's in a row. What I need is to also
count HD as .5 in the same row and add it to the final total.

For instance in the first row H     H     HD   H = 3.5. I may at a later
date also need to add to it again with a S also to count 1.
Can anyone help with the formula please. Maybe COUNTIF isn't the correct one
to use.

Thanks.

Bryan.