| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT using multiple conditions
I need excel to count the number of rows which contain both of two conditions in seperate cells. the condtions are a specified number AND a specified letter, if the row only contains one of either conditions i need excel to ignore it, but if it contains both then count it as one. I have used the SUMPRODUCT function but it doesnt seem to work, im guessing because one of the conditions is text not numerical any ideas? many thanks -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=510798 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
| returning a count if two conditions are met | Excel Worksheet Functions | |||
| Sum If Multiple Conditions | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
