| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting instances that 2 different columns match
I am trying to enter a formula to do the following:
I am trying to have one cell count the number of times a name appears in one column while a value also appears in another alongside of it Ex: Column A Column B Bill 1 Steve 1 Harry 0 Bill 1 Harry 1 Bill 0 Steve 1 ........ I am looking for a formula that tells me how many times Bill appears in column A and 1 appears in column B alongside it (has to be both Bill and 1) The example above should give me a result of 2 Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match names in 2 different columns | Excel Discussion (Misc queries) | |||
| counting cells in two columns that have the same results | Excel Worksheet Functions | |||
| Counting columns of dates | Excel Discussion (Misc queries) | |||
| Counting rows with 3 columns | Excel Worksheet Functions | |||
| counting in one column when two expressions in two other columns are true | Excel Worksheet Functions | |||
Threaded Mode
