| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text based on multiple (2) conditions | Excel Worksheet Functions | |||
| Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
| How do I count based on two conditions? | New Users to Excel | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
| Count Based upon Multiple Conditions | Excel Worksheet Functions | |||
Threaded Mode
