| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count based on multiple conditions
Excel2003 ... I need to compare & count based on multiple conditions ...
WorkBook contains 2 WorkSheets (WS1 & WS2) ... Need Formula in WS2, Col H that will: Compare WS2 ... Cols B & C values with values found in WS1 ... Cols C & H Count occs where WS2, Cols B & C values match WS1 Cols C & H values. Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count based on multiple conditions
See if this works for you:
=SUMPRODUCT(--('WS1'!C1:C100=B1:B100),--('WS1'!H1:H100=C1:C100)) HTH, Elkar "Ken" wrote: Excel2003 ... I need to compare & count based on multiple conditions ... WorkBook contains 2 WorkSheets (WS1 & WS2) ... Need Formula in WS2, Col H that will: Compare WS2 ... Cols B & C values with values found in WS1 ... Cols C & H Count occs where WS2, Cols B & C values match WS1 Cols C & H values. Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
| 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 Based upon Multiple Conditions | Excel Worksheet Functions | |||
Linear Mode
