Countif Frequency Dilemma

[Splinter4543]

I am having an issue writing a frequency fromula for two sets of data. I have three sets of criteria for example: Big store, Small Store, Medium Store. The data would like this:

Column A Column B
Store # Store Type
1 Big Store
1 Big Store
1 Big Store
1 Big Store
1 Big Store
2 Small Store
2 Small Store
3 Medium Store
3 Medium Store
3 Medium Store
4 Big Store
4 Big Store
5 Small Store
5 Small Store

In this example I have 2 "Big Stores", 2 "Small Stores", and 1 "Medium Store".

I cant figure out the formuals do this for the life of me! Any help would be appreciated!

[Kevin UK]

Hi Splinter4543

Assuming the data is in A1:B15.

Try in B2 and copy down:

Please Login or Register  to view this content.

Then in C2:

Please Login or Register  to view this content.

CTRL + SHIFT + ENTER to commit and copy down.

[Splinter4543]

Let me give you a better idea of what I'm looking for. I am hoping to have these values in 3 cells one for eahc of the criteria (big store, small store etc...) I'm also trying to keep the size of the file small. What I am looking to do is accomplish this in one formula to count the total number of unique times in realtion to store number "big store" come up, "small store" comes up, and "medium store" comes up.

Any clearer, or maybe this is not a possibility. Thanks for all the help so far, this one is taking up the majority of my day!

[Splinter4543]

Bump! Thanks in Advance!

[Splinter4543]

Ive attached a document with an example of what im trying to do. Thanks again for the help!

[Fotis1991]

Perhaps..

In C5 and copy down.

=COUNTIFS($A$5:A5;A5;$B$5:B5;B5)

In I4 and copy across..

=COUNTIFS($B$5:$B$41;I$3;$C$5:$C$41;1)

[Splinter4543]

Perfect thank you!

[Fotis1991]

........................