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

On 14/06/2012 9:43 PM, Beeee wrote:
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.

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Hi, without an example workbook it's hard to tell exactly what you're 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 the 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 each 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"... My bad. :(

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

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

This seems to have worked!!!

Thank you very much
:) ;)

No worries Spencer - Thanks :)