About Us

Spencer101

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.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Build formula using field values as text in the formula referencing another workbook	solardirect	Links and Linking in Excel	6	June 4th 12 10:47 PM
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula	PJ[_3_]	Excel Worksheet Functions	2	June 2nd 10 03:45 PM
copy formula down a column and have cell references change within formula	brad	New Users to Excel	5	May 13th 07 04:38 PM
Formula expected end of statement error, typing formula into cell as part of VBA macro	[email protected]	Excel Programming	1	July 20th 06 07:58 PM
Commenting custom formula fields/formula on formula editor	Muxer	Excel Programming	2	July 24th 03 01:02 AM

Menu

About Us