Excel 2007 : Count a range with two conditions

[sam10]

Hi,

I am trying to count a range with two conditions.
Have to count number of resolved defects where issue type is "Defect/Deficiency" & date is "mm/dd/yyy" and then create a graph.

I used the function as :
=COUNTIF(Source!B$4:B$500,DAYS360($Q$2,A2))
where B4:B500 is the resolved date column, Q2 value is 1/1/2012 & A2 is date 3/2/2012

it gives me the correct count but i need to put one more criteria, as count only those where Source!C$4:C$500 = Defect/Deficiency.

I tried using
=COUNT((IF(Source!B$4:B$500="DAYS360(graph!$Q$2,graph!A2)",IF(Source!C$4:C$500="Source!C$4",1,0))))

and also tried using

=SUM((IF(Source!B$4:B$500="DAYS360(graph!$Q$2,graph!A2)",IF(Source!C$4:C$500="Source!C$4",1,0))))

but not getting the answer.

Any help will be greatful

[dilipandey]

Hi Sam,

Since you are using Excel2007, try using CountIFs or may be SUMIFs, ... upload a sample file in case of any issues. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[sam10]

Hi DILIP,

Thanks a lottttttttttttttttt
COUNTIFS solved the problem.

Great help

[dilipandey]

You are welcome Sam..

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>