count with 2 conditions for many rows ?
 

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


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

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

count with 2 conditions for many rows ?
 

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

count with 2 conditions for many rows ?
 

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" wrote in
message ...

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


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

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

count with 2 conditions for many rows ?
 

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

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

Thanks again


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

count with 2 conditions for many rows ?
 

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


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