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..