Originally Posted by Beeee

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

Originally Posted by Spencer101

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.

Originally Posted by Beeee

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 :)

Originally Posted by Spencer101

Sorry, the last "C" in the formula I have should have been "H"... My bad. :(

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

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