countif counting properties
 

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

countif counting properties
 

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

countif counting properties
 

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

countif counting properties
 

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

countif counting properties
 

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

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