Formula

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

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
 
B

Bryan De-Lara

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

Tyro

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

Tyro
 
B

Bryan De-Lara

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

Bryan.
 
Top