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




"needs help" <needs wrote in
message
...
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