Count Formula

[Chandrasheka]

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]

Try

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

[mohanvijay]

Hai you can use Dcounta function

i have attached the solved one

[Chandrasheka]

Hi,

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

Thanks in advance

Regards,

Chandra Shekar

[Bob Phillips]

You can't use COUNTIF, unless you have Excel 2007, as you have two conditions.