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

Thanks so much

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 then
using CTRL/SHIFT/ENTER to enter the formula, it will then show in the
formula bar like this {=SUM((C1:C8="Defect Fixing")*(D1:D8="New"))}

Change the cell ranges C1:C8 and D1:D8 to suit your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=477425