2 conditions needed to check and count of items based on that
 

Hi,

I have some 10 rows of data with 5 columns. one column has got data like
'Reports', 'Interface', 'Conversion' and these values might be present in
more than one row. one more column has status = 'Y' or 'N'. I want to get a
count of no of rows with column1='Reports' and column2(status)='Y'.

How can i achieve this? Please help..

I tried using SUMIF, COUNTIF..but did not work..

2 conditions needed to check and count of items based on that
 

Use something like
=SUM(IF($B$2:$B$9="Report",IF($C$2:$C$9="Y",1,0),0 ))
And press Ctrl+Shift+Enter after entering it.

DQ

2 conditions needed to check and count of items based on that
 

=SUMPRODUCT(-(A2:A10="Reports"),-(B2:B10="y"))


"Vijay" wrote:

Hi,

I have some 10 rows of data with 5 columns. one column has got data like
'Reports', 'Interface', 'Conversion' and these values might be present in
more than one row. one more column has status = 'Y' or 'N'. I want to get a
count of no of rows with column1='Reports' and column2(status)='Y'.

How can i achieve this? Please help..

I tried using SUMIF, COUNTIF..but did not work..