Formula Help Please - ExcelBanter

Spencer101 Spencer101 is offline

Senior Member

Posts: 663

Quote:

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

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

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

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 08:22 AM.

Menu

About Us