Hi,
The attached document contains one "form" with radiobuttons etc. The idea as that this sheet will be a standalone document for users to fill in. I will receieve all these files and copy the sheet into this attached master document. So in the future the document will have a lot of sheets (might be better off keeping them as seperate files, as I expect about 100+ sheets a year)
Anyhow, my problem is that I'm trying to aggregate all the data from these sheets by creating a "database" (One row for each sheet). From this database I'm now trying to sort the data into tables that will be the dataset for graphs and statistical calculations.
In sheet "Summary" you see first a mock-up for the database. And below B18:B30 is the dataset. In C19 I'm trying to make a formula that will count the number of won contracts if it is in january 2010.
It would be great to get some help on which formula to use in C8:D19.
Any input on the overall structure of the Excel sheet would also be great
Bookmarks