About Us

Beeee

Quote:

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.

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

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