=Sum with a variation

Posted by Steve Webb on September 06, 2001 1:38 PM

Please, can anyone help me with this, my brain hurts!.
I am trying to total hours in Cols Saturday to Friday, no problem with that. But then I threw in H for holidays and S for sick etc, is it possible to have a formula that will recognise these H's and S's etc to give me a seperate total?
Thanks for any help

Steve

Posted by Aladin Akyurek on September 06, 2001 1:45 PM

Steve

Can you post 5 rows of your data?

Aladin

Posted by SteveWebb on September 08, 2001 7:51 AM

Aladin
Thanks for looking at this problem,
I have used countif to answer the query.
Steve