| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Based on Comparison with Two Fields
I recently learned that I can count the number of items in one column that
match items in another column by using: =COUNT(MATCH( 'Sheet1'!G2:G15001, 'Sheet2'!A2:A15, 0)) However, I now need to count records on one sheet in which TWO fields match items in both of two separate columns (i.e., a comparison of two columns to two columns and a count of records in the first that have fields matching elements in the second) . My attempt to use the above statement with an AND failed. Can someone explain how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count based on multiple criteria fields w/duplicates | Excel Worksheet Functions | |||
| How do I count based on conditions on two fields in data? | Excel Discussion (Misc queries) | |||
| Isolating single row based on date comparison | Excel Worksheet Functions | |||
| count based on two fields- need as quick as possible | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
Threaded Mode
