countif counting properties

[Guest]

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

 

[Peo Sjoblom]

How about dividing the countif result with 2?

 

[Guest]

I dont think this will work. As it needs to add up in the same cell as the
rest of the formulas. It is for a holiday tracking document, Everytime I add
H it stands for one holiday day( 1). Everytime I put in HD is stands for Half
day (0.5) and they are both totalled in the same cell which is subtracted
from the allowance.

Any other suggestions?

Thanks for your help

 

[Peo Sjoblom]

So why didn't you say so from the start?

=COUNTIF(A:A,"H")+(COUNTIF(A:A,"HD")/2)

=SUMPRODUCT(COUNTIF(A2:A200,{"H","HD"})*{1,0.5})

 

[Guest]

Sorry,
Thanks alot for your help.

regards,
Darryl

 

[Peo Sjoblom]

Thanks for the feedback

Peo

Sorry,
Thanks alot for your help.

regards,
Darryl