countif counting properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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})
 
Back
Top