Continuous count based on two factors

[Luke1979]

Hey guys, this is my first time posting on the forum but I have always gotten a lot of help from reading other posts.

Here is my question:

I have a workbook in which I have created a tracking program with a user interface, the information posted to the interface gets stored into hidden worksheets in the workbook. I want to have a count of the information on the interface. One of the counts specifically is how many beanie hats were bought each year. I need a formals, probably VBA that will constantly keep a count of how many blue beanie hats were bought in 2011 and display that count on the interface. I am using excel 2003. another important thing to note is that the data is being updated by users on a continual basis and while the information IS being somewhat controlled by limiting choices to drop down boxes, there are several different variables (hats, shirts, pants, shorts ect.) and the year the item was sold can vary as well, as in it goes back before 2011 and will continue past 2011.

Thanks!

 

[paddydive]

Hi Luke,

Have you tried Pivot Table.

You can creat a Pivot Table and refresh it and it will give you the how many blue beabie hats were bought.

Hope it works for you.