If you want the result formatted as shown, use a Pivot table. Generate it by
selecting it from the Data menu and following the prompts.

Otherwise you can use a formula to count the occurrences (assumes 'Store' is
in A1 and 'Category' is in B1)

=sumproduct(--(a2:a1000="A") , --(B2:b1000=1))

Change the ="A" and the =1 to reflect your actual values



"Oggie Ben Doggie" wrote:

I have a table like this:
(sorry if the message mangles it, but there are tabs so you can paste
it correctly if you need to... I think)

Store Category Item
A 1 blahblah
A 1 blahblah
B 1 blahblah
B 1 blahblah
A 2 blahblah
A 2 blahblah
A 2 blahblah
A 2 blahblah
A 2 blahblah
B 2 blahblah
A 3 blahblah
B 3 blahblah
C 3 blahblah

I'd like to use a countif formula to generate the occurrences column.
Ideas?

Results
Location Category Number of Occurrences
A 1 2
2 5
3 1
B 1 2
2 1
3 1
C 1 0
2 0
3 1