Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif/sumproduct on multiple criteria
looking for help with following
a1 b1 c1 x r m x s m t r m x r d y r m The problem is I want to count the occurences of m if (a1 = x and b1 = r) and if (a1 = y and b1 =r) the solution I am looking for is ( 2 in the above table) I have about 500 lines of data to process * note ( range of a1 cell are merged ,ie: a1+a2 a3+a4 ect..) any solution would be helpful. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
sumproduct using multiple criteria | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |