| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF Multiple Criteria
I need a formula that will look count the number of occurrences in one column
that equal a criteria only if the a criteria in another column is met. Neither of the two columns contain numbers. For instance Column A has a type of fruit, column B has the seller of the fruit. I need to know how many of a particular fruit the specified seller sells. Thank you! -- Lori -- Lori |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNTIF Multiple Criteria
=SUMPRODUCT(--(A1:A100="apple"),--(B1:B100="Bill"))
-- HTH RP (remove nothere from the email address if mailing direct) "Lori Hornick" wrote in message ... I need a formula that will look count the number of occurrences in one column that equal a criteria only if the a criteria in another column is met. Neither of the two columns contain numbers. For instance Column A has a type of fruit, column B has the seller of the fruit. I need to know how many of a particular fruit the specified seller sells. Thank you! -- Lori -- Lori |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with multiple criteria | Excel Discussion (Misc queries) | |||
| COUNTIF with multiple criteria | Excel Worksheet Functions | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| multiple criteria in a countif | Excel Programming | |||
Linear Mode
