Hi Beeee,

Am Fri, 15 Jun 2012 11:23:57 +0000 schrieb Beeee:

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.

each person has a own row:
=SUM(COUNTIF(C7:CM7,{"H","C"}))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

This seems to have worked!!!

Thank you very much
:) ;)