count with 2 conditions for many rows ?

[kevink79]

Hello i got this problem in Excel. Can you please to give me th
function or any tip to do that ? The attach filed consists of a tabl
and question.

Thanks so muc

+-------------------------------------------------------------------
|Filename: Question.doc
|Download: http://www.excelforum.com/attachment.php?postid=3918
+-------------------------------------------------------------------

 

[Paul Sheppard]

Hello i got this problem in Excel. Can you please to give me th
function or any tip to do that ? The attach filed consists of a tabl
and question.

Thanks so much

Hi kevink79

Try this formula > =SUM((C1:C8="Defect Fixing")*(D18="New"))
enterred as an array by typing the formula into an empty cell and the
using CTRL/SHIFT/ENTER to enter the formula, it will then show in th
formula bar like this > {=SUM((C1:C8="Defect Fixing")*(D18="New"))}

Change the cell ranges C1:C8 and D18 to suit your dat

 

[Bob Phillips]

Didn't see or open any attachments, but basic principle

=SUMPRODUCT(--(A2:A200="value1"),--(B2:B200=value2))

one text test, one numeric test

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[kevink79]

Hello Paul, i've alreay got the the expected output. Thanks too much

While your formula is simple but effective but i tried many comple
functions with Count, If, And but ineffective at all.

Thanks agai

 

[kevink79]

I've tried to name the column and use this name as range for later
extension but could not