| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count occurrences when two conditions are met
One column contains names. the other numbers. I'd like to count the number
of times two conditions are met. e.g., how many times does the name Smith in column A come up with the number 90 in column B. Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count occurrences when two conditions are met
Use =SUMPRODUCT()
=SUMPRODUCT((A1:A1000="Smith")*(B1:B1000=90)) Alwasy consider SUMPRODUCT when you have moe than one criteria. -- Gary''s Student - gsnu200860 "Steve" wrote: One column contains names. the other numbers. I'd like to count the number of times two conditions are met. e.g., how many times does the name Smith in column A come up with the number 90 in column B. Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting occurrences with conditions | Excel Discussion (Misc queries) | |||
| conditions and count occurrences of "not blank" | Excel Discussion (Misc queries) | |||
| how do I count occurrences of multiple conditions | Excel Worksheet Functions | |||
| how do I count the occurrences of multiple conditions | Excel Worksheet Functions | |||
| €śCount€ť occurrences of two conditions on the same row | Excel Worksheet Functions | |||
Linear Mode
