| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching two columns against a specific criteria
Hi,
I have a range of data in A2:G30. The cells in range A2:A30 have either 'yes' or 'no' as text in the cells. The cells in range D2:D30 have either 'David', 'Andrew', 'Charles' or 'John' as text in cells. I want to put in cell K50 a function that returns the number of times that 'Charles' is mentioned in column D and where 'yes' is in the same row and mentioned in column A. I have tried 'sumproduct' but this only returns '0' and according to Excel help only works with numerical data in the cells. Please can anyone help. Many thanks -- Thank you, Colin. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count across multiple columns, using specific criteria | Excel Discussion (Misc queries) | |||
| Summing specific Columns based on Criteria | Excel Discussion (Misc queries) | |||
| Searching rows with multiple columns criteria | Excel Worksheet Functions | |||
| Sum rows if two columns = specific criteria. | Excel Worksheet Functions | |||
| searching for specific criteria and then doing an action based on | Excel Discussion (Misc queries) | |||
Threaded Mode
