formula to count occurence of criteria in 2 columns

[Guest]

Hi,
Background:Column A is a source type and Column B represents "B" Buyer & "S"
Seller. I am trying to count (automatically) the number of times that a "B"
in Column B corresponds with "website" in Column "A"

Column A Column B
Direct Mail S
Dan's SOI S
Website B
Dan's SOI S
Dan's SOI S
Dan's SOI S
Website S
Dan's SOI S
Website B
Direct Mail S
Website B

Thanks for your help

 

[kraljb]

=SUMPRODUCT(--($A$1:$A100="website"),--($B$1:$B$100="B")

 

[Chip Pearson]

Try

=SUMPRODUCT((A1:A10="Website")*(B1:B10="B"))

Change the ranges to suit your needs.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
news[email protected]...