Hi All,

I'm trying to locate a formula where I can make my work easy.
The questions is: I've 15 sheets(1 sheet for each employee) in a workbook,
where we store the data of alloted work and in them we got 12 variety of
issues. So what I'm trying to do is - count/Sum the action and the date i.e,
how many persons have did how many varieties on that particular date. I have
one master where am I'm gonna insert this formula.


Example:
Action Taken Date
Wrong Image 26/04/2008
Wrong Image 26/04/2008
Wrong Image 26/04/2008
Wrong Image 27/04/2008
Wrong Image 27/04/2008
Missing Pages 27/04/2008
Missing Pages 27/04/2008
Missing Pages 28/04/2008
Missing Pages 28/04/2008
Missing Pages 28/04/2008
Missing Pages 28/04/2008
Missing Pages 28/04/2008



DATE Wrong Image Missing Pages Foreign Language Total
Apr-01 =sum of all employees data for this particular issue 0 0 0
Apr-02 0 0 0 0
Apr-03 0 0 0 0
Apr-04 0 0 0 0
Apr-05 0 0 0 0
Apr-06 0 0 0 0
Apr-07 0 0 0 0
Apr-08 0 0 0 0
Apr-09 0 0 0 0
Apr-10 0 0 0 0
Apr-11 0 0 0 0
Apr-12 0 0 0 0
Apr-13 0 0 0 0
Apr-14 0 0 0 0
Apr-15 0 0 0 0
Apr-16 0 0 0 0
Apr-17 0 0 0 0
Apr-18 0 0 0 0
Apr-19 0 0 0 0
Apr-20 0 0 0 0
Apr-21 0 0 0 0
Apr-22 0 0 0 0
Apr-23 0 0 0 0
Apr-24 0 0 0 0
Apr-25 0 0 0 0
Apr-26 12 0 0 0
Apr-27 0 0 0 0
Apr-28 0 0 0 0
Apr-29 0 0 0 0
Apr-30 0 0 0 0