software

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

How about dividing the countif result with 2?

--

Regards,

Peo Sjoblom

quot;Darrylquot; gt; wrote in message
news
gt; Hey.
gt; I am using countif to total the number of H's in a group of cells,
everytime
gt; it counts a H it counts a whole number.
gt; I need to use a formula where instead of counting a whole number it counts
gt; up in 0.5 per H.
gt; Any suggestions?
gt; Your help would be much appreciated.
gt; Thanks
gt; 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

quot;Peo Sjoblomquot; wrote:

gt; How about dividing the countif result with 2?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Darrylquot; gt; wrote in message
gt; news
gt; gt; Hey.
gt; gt; I am using countif to total the number of H's in a group of cells,
gt; everytime
gt; gt; it counts a H it counts a whole number.
gt; gt; I need to use a formula where instead of counting a whole number it counts
gt; gt; up in 0.5 per H.
gt; gt; Any suggestions?
gt; gt; Your help would be much appreciated.
gt; gt; Thanks
gt; gt; Darryl
gt;
gt;
gt;

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

=COUNTIF(A:A,quot;Hquot;) (COUNTIF(A:A,quot;HDquot;)/2)

=SUMPRODUCT(COUNTIF(A2:A200,{quot;Hquot;,quot;HDquot;})*{1,0.5})--

Regards,

Peo Sjoblom

quot;Darrylquot; gt; wrote in message
...
gt; I dont think this will work. As it needs to add up in the same cell as the
gt; rest of the formulas. It is for a holiday tracking document, Everytime I
add
gt; H it stands for one holiday day( 1). Everytime I put in HD is stands for
Half
gt; day (0.5) and they are both totalled in the same cell which is subtracted
gt; from the allowance.
gt;
gt; Any other suggestions?
gt;
gt; Thanks for your help
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; How about dividing the countif result with 2?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;Darrylquot; gt; wrote in message
gt; gt; news
gt; gt; gt; Hey.
gt; gt; gt; I am using countif to total the number of H's in a group of cells,
gt; gt; everytime
gt; gt; gt; it counts a H it counts a whole number.
gt; gt; gt; I need to use a formula where instead of counting a whole number it
counts
gt; gt; gt; up in 0.5 per H.
gt; gt; gt; Any suggestions?
gt; gt; gt; Your help would be much appreciated.
gt; gt; gt; Thanks
gt; gt; gt; Darryl
gt; gt;
gt; gt;
gt; gt;
Sorry,
Thanks alot for your help.

regards,
Darryl

quot;Peo Sjoblomquot; wrote:

gt; So why didn't you say so from the start?
gt;
gt; =COUNTIF(A:A,quot;Hquot;) (COUNTIF(A:A,quot;HDquot;)/2)
gt;
gt; =SUMPRODUCT(COUNTIF(A2:A200,{quot;Hquot;,quot;HDquot;})*{1,0.5})
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;Darrylquot; gt; wrote in message
gt; ...
gt; gt; I dont think this will work. As it needs to add up in the same cell as the
gt; gt; rest of the formulas. It is for a holiday tracking document, Everytime I
gt; add
gt; gt; H it stands for one holiday day( 1). Everytime I put in HD is stands for
gt; Half
gt; gt; day (0.5) and they are both totalled in the same cell which is subtracted
gt; gt; from the allowance.
gt; gt;
gt; gt; Any other suggestions?
gt; gt;
gt; gt; Thanks for your help
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt; gt; How about dividing the countif result with 2?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Regards,
gt; gt; gt;
gt; gt; gt; Peo Sjoblom
gt; gt; gt;
gt; gt; gt; quot;Darrylquot; gt; wrote in message
gt; gt; gt; news
gt; gt; gt; gt; Hey.
gt; gt; gt; gt; I am using countif to total the number of H's in a group of cells,
gt; gt; gt; everytime
gt; gt; gt; gt; it counts a H it counts a whole number.
gt; gt; gt; gt; I need to use a formula where instead of counting a whole number it
gt; counts
gt; gt; gt; gt; up in 0.5 per H.
gt; gt; gt; gt; Any suggestions?
gt; gt; gt; gt; Your help would be much appreciated.
gt; gt; gt; gt; Thanks
gt; gt; gt; gt; Darryl
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

Thanks for the feedback

Peoquot;Darrylquot; gt; wrote in message
...
gt; Sorry,
gt; Thanks alot for your help.
gt;
gt; regards,
gt; Darryl
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; So why didn't you say so from the start?
gt; gt;
gt; gt; =COUNTIF(A:A,quot;Hquot;) (COUNTIF(A:A,quot;HDquot;)/2)
gt; gt;
gt; gt; =SUMPRODUCT(COUNTIF(A2:A200,{quot;Hquot;,quot;HDquot;})*{1,0.5})
gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;Darrylquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I dont think this will work. As it needs to add up in the same cell as
the
gt; gt; gt; rest of the formulas. It is for a holiday tracking document, Everytime
I
gt; gt; add
gt; gt; gt; H it stands for one holiday day( 1). Everytime I put in HD is stands
for
gt; gt; Half
gt; gt; gt; day (0.5) and they are both totalled in the same cell which is
subtracted
gt; gt; gt; from the allowance.
gt; gt; gt;
gt; gt; gt; Any other suggestions?
gt; gt; gt;
gt; gt; gt; Thanks for your help
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; How about dividing the countif result with 2?
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Regards,
gt; gt; gt; gt;
gt; gt; gt; gt; Peo Sjoblom
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Darrylquot; gt; wrote in message
gt; gt; gt; gt; news
gt; gt; gt; gt; gt; Hey.
gt; gt; gt; gt; gt; I am using countif to total the number of H's in a group of cells,
gt; gt; gt; gt; everytime
gt; gt; gt; gt; gt; it counts a H it counts a whole number.
gt; gt; gt; gt; gt; I need to use a formula where instead of counting a whole number
it
gt; gt; counts
gt; gt; gt; gt; gt; up in 0.5 per H.
gt; gt; gt; gt; gt; Any suggestions?
gt; gt; gt; gt; gt; Your help would be much appreciated.
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt; gt; Darryl
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;