countif counting properties
Thanks for the feedback
Peo
"Darryl" wrote in message
...
Sorry,
Thanks alot for your help.
regards,
Darryl
"Peo Sjoblom" wrote:
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})
--
Regards,
Peo Sjoblom
"Darryl" wrote in message
...
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" wrote:
How about dividing the countif result with 2?
--
Regards,
Peo Sjoblom
"Darryl" wrote in message
...
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
|