Count sales of different products to same customer Excel

[cdubs34]

Hello,

I am trying to get at some cross buying behavior from a large data set that I have. Here is simple, example of the Pivot Table I have put together so far:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Brand A[/TD]
[TD]Brand B[/TD]
[TD]Brand C[/TD]
[TD]Brand D[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mark[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

Essentially I am trying to put together a grid that shows the number of instances where someone buys both Brand A and another brand. Is there a formula that would get at this? Thank you.

 

[Latchmaker]

<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th></th><th>Brand A</th><th>Brand B</th><th>Brand C</th><th>Brand D</th><th>Brand A and Qty of Other Brands</th></tr></thead><tbody>
<tr><td>John</td><td>1</td><td> </td><td>2</td><td> </td><td>=IF(ISNUMBER(B2),COUNT(C2:E2),"")</td></tr>
<tr><td>Mark</td><td> </td><td>1</td><td> </td><td> </td><td>=IF(ISNUMBER(B3),COUNT(C3:E3),"")</td></tr>
<tr><td>Amy</td><td>1</td><td> </td><td> </td><td>1</td><td>=IF(ISNUMBER(B4),COUNT(C4:E4),"")</td></tr>
</tbody></table>