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

=SUMPRODUCT(--(A1:A100="apple"),--(B1:B100="Bill"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lori Hornick" <[email protected]> wrote in message
news:[email protected]...
> 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