Formula

[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.

 

[Barb Reinhardt]

=COUNTIF(B208:AE208,"H") - COUNTIF(B208:AE208,"HD")

 

[Tyro]

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

 

[Bryan De-Lara]

Thank you both, works just fine...

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

 

[Tyro]

Both formulas cannot work "Just fine" the two formulas produce different
answers.

Tyro

 

[Bryan De-Lara]

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

Bryan.