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.