| Home |
| Search |
| Today's Posts |
|
#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, |
| 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 | |||
Threaded Mode
