| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine a result of one column based on conditions in two column
Example
Col A Col B Count the number of a's in Col B only when an x is in Col A x a x a Result should be 2 y a z p I can't figure it out x t x m Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Determine a result of one column based on conditions in two column
try this
=SUMPRODUCT(--(A2:A7="x"),--(B2:B7="a")) -- Hope this help Please click the Yes button below if this post have helped answer your needs Thank You cheers, francis "tel703" wrote: Example Col A Col B Count the number of a's in Col B only when an x is in Col A x a x a Result should be 2 y a z p I can't figure it out x t x m Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding the largest value for a name in a column and then returningthe result from a different column | Excel Worksheet Functions | |||
| How to determine the values based on given conditions? | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Formula to Extract value on 3 column based on two conditions | Excel Discussion (Misc queries) | |||
| Determine if Value in column A exists in Column B | Excel Discussion (Misc queries) | |||
Linear Mode
