Formula

  • Thread starter Thread starter Bryan De-Lara
  • Start date Start date
B

Bryan De-Lara

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.
 
Perhaps: =COUNTIF(B208:AE208,"H")+COUNTIF(B208:AE208,"HD")/2
You might want to add the ROUND function to the second COUNTIF to round up.

Tyro
 
Thank you both, works just fine...:)

Bryan.


Tyro said:
Perhaps: =COUNTIF(B208:AE208,"H")+COUNTIF(B208:AE208,"HD")/2
You might want to add the ROUND function to the second COUNTIF to round
up.

Tyro
Click to expand...
 
Yes agreed, yours works fine, but I was thanking both for taking the trouble
to answer, sorry for the confusion.

Bryan.
 
Back
Top