count with 2 conditions for many rows ?

  • Thread starter Thread starter kevink79
  • Start date Start date
K

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
+-------------------------------------------------------------------
 
kevink79 said:
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
Click to expand...

Hi kevink79

Try this formula > =SUM((C1:C8="Defect Fixing")*(D1:D8="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")*(D1:D8="New"))}

Change the cell ranges C1:C8 and D1:D8 to suit your dat
 
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)
 
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
 
I've tried to name the column and use this name as range for later
extension but could not
 
Back
Top