Assuming your results table starts in A1:
Enter the following in B2, then copy down, then copy across. (or across
then down if you prefer)



=SUMPRODUCT((Sheet1!$A$2:$A$15=Sheet2!$A2)*(Sheet1 !$B$2:$B$15=Sheet2!B$1))

"Jim" wrote:

Yodas,

Thanks for your help.

On sheet one I have data from a report. In column A it lists store numbers.
In column B it lists either a 1 or a 2.

A B
101 1
102 1
103 2
101 2
102 2
103 2
101 2
102 2
103 1
101 2
102 2
103 2
101 1
102 2


On sheet two I have the store number listed and would like to sum all the
1s if it matches the store number.

A B C
1's 2's
Store 101 2 3
Store 102 1 4
Store 103 1 3


Thanks for the help.