Formula Help Please

[Beeee]

Hi,

I'm working on a s/sheet (excel 2003) for holidays where I have entere
H or C on some cells where holidays have been taken.

I want to calculate anywhere I have a H or C, I use
=COUNTIF(C20:CM28,"H*") but that only gives me the H value but no
sure how to get the value for more than one letter

Can anyone help me please….?

Thank

 

[Vacuum Sealed]

Hi,

I'm working on a s/sheet (excel 2003) for holidays where I have entered
H or C on some cells where holidays have been taken.

I want to calculate anywhere I have a H or C, I used
=COUNTIF(C20:CM28,"H*") but that only gives me the H value but not
sure how to get the value for more than one letter

Can anyone help me please….?

Thanks

Hi

Try it this way

=COUNTIF(C20:CM28, "=H*")

HTH
Mick.

 

[Claus Busch]

Hi Beeee,

Am Thu, 14 Jun 2012 11:43:47 +0000 schrieb Beeee:

I want to calculate anywhere I have a H or C, I used
=COUNTIF(C20:CM28,"H*") but that only gives me the H value but not
sure how to get the value for more than one letter

try:
=SUM(COUNTIF(C20:CM28,{"H","C"}))


Regards
Claus Busch

 

[Spencer101]

Hi,

I'm working on a s/sheet (excel 2003) for holidays where I have entere
H or C on some cells where holidays have been taken.

I want to calculate anywhere I have a H or C, I use
=COUNTIF(C20:CM28,"H*") but that only gives me the H value but no
sure how to get the value for more than one letter

Can anyone help me please….?

Thanks

Hi, without an example workbook it's hard to tell exactly what you'r
trying to do. But perhaps the below formula will help....

=COUNTIF(C20:CM28,\"C\")+COUNTIF(C20:CM28,\"C\"

Let us know if that's what you meant or not

 

[Beeee]

Hi, without an example workbook it's hard to tell exactly what you'r
trying to do. But perhaps the below formula will help....

=COUNTIF(C20:CM28,\"C\")+COUNTIF(C20:CM28,\"C\"

Let us know if that's what you meant or not.

Thanks for you replies back but for some reason it's not giving me th
correct information

I have attached an example of s/sheet i'm working on.
What I want to do is culculate the number of holidays (H & C's) for eac
person to give me a total on the end of each person's row.
I hope this make more sense.

Thanks again :

+-------------------------------------------------------------------
|Filename: July, August & September 2012 Holidays.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=425
+-------------------------------------------------------------------

 

[Spencer101]

Thanks for you replies back but for some reason it's not giving me th
correct information

I have attached an example of s/sheet i'm working on.
What I want to do is culculate the number of holidays (H & C's) for eac
person to give me a total on the end of each person's row.
I hope this make more sense.

Thanks again

Sorry, the last "C" in the formula I have should have been "H"... M
bad.

*=COUNTIF(C20:CM28,"C")+COUNTIF(C20:CM28,"H")

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi Beeee,

Am Fri, 15 Jun 2012 11:23:57 +0000 schrieb Beeee:

I have attached an example of s/sheet i'm working on.
What I want to do is culculate the number of holidays (H & C's) for each
person to give me a total on the end of each person's row.
I hope this make more sense.

each person has a own row:
=SUM(COUNTIF(C7:CM7,{"H","C"}))


Regards
Claus Busch

 

[Beeee]

Hi Beeee,

Am Fri, 15 Jun 2012 11:23:57 +0000 schrieb Beeee:
-

each person has a own row:
=SUM(COUNTIF(C7:CM7,{"H","C"}))


Regards
Claus Busch

This seems to have worked!!!

Thank you very much
;

+-------------------------------------------------------------------
+-------------------------------------------------------------------