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