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