Chandrasheka
08-18-2010, 04:30 AM
Hi,
I am looking for excel formula which should meet two conditions.
In Column A : Emp Name: A, B, C, D, E
In Column B : Date of Joining : 01/05/2001,02/01/1999,03/05/2003,04/09/2002,05/07/2007
In Column C : Process : Voice, Non Voice, Voice, Non Voice, Non Voice
Here I need formula which should tell the count how many employees of non voice process joined from the year 2001
Answer is for the above condition is 2.
Please help it out. Thanks in advance.
Regards,
Chandra Shekar
I am looking for excel formula which should meet two conditions.
In Column A : Emp Name: A, B, C, D, E
In Column B : Date of Joining : 01/05/2001,02/01/1999,03/05/2003,04/09/2002,05/07/2007
In Column C : Process : Voice, Non Voice, Voice, Non Voice, Non Voice
Here I need formula which should tell the count how many employees of non voice process joined from the year 2001
Answer is for the above condition is 2.
Please help it out. Thanks in advance.
Regards,
Chandra Shekar