Quote:
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
|
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.