| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif and Text - not counting | Excel Discussion (Misc queries) | |||
| Using COUNTIF for Counting Words? | Excel Worksheet Functions | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| counting values within given interval - countif? | Excel Discussion (Misc queries) | |||
| counting cells (COUNTIF) based on two or more criteria | Excel Worksheet Functions | |||
Linear Mode
