PDA

View Full Version : Count Formula



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

Bob Phillips
08-18-2010, 05:05 AM
Try

=SUMPRODUCT(--(YEAR(B2:B20)>2000),--(C2:C20="Non Voice"))

mohanvijay
08-19-2010, 12:25 PM
Hai you can use Dcounta function

i have attached the solved one

Chandrasheka
08-25-2010, 08:21 AM
Hi,

I am not getting desired output. How to use countif formula for this problem.

Thanks in advance

Regards,

Chandra Shekar

Bob Phillips
08-25-2010, 08:35 AM
You can't use COUNTIF, unless you have Excel 2007, as you have two conditions.