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

G

Guest

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

dq

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count a coloum if two conditions are met 5
Count based on 2 conditions 4
Formula to count data in a column that falls between a range 3
Count rows based on multiple criteria 3
Count nonblank cells based on another column 1
Sumproduct Count, Allow Or Two Fields 2
Count rows that meet 2 conditions in Excel 2007 3
Using countif with 2 conditions 2

Top