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

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

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


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=390738