I've attached a file with some sample data and some text explaining what I'm trying to do.
I work at a parts factory, and log every part I inspect into a spreadsheet. In one of the columns I record the date, and in another I record the quantity of parts. (Usually it's just 1, but sometimes it's multiple.)
I could easily get the total parts so far this year, but I would like to break it down per month.
I know I could go back and manually count how many I did per month, but I would like it to work automatically as the year progresses.
Does this make sense to anyone? If you'll look at the very top of the "2009" sheet in my example, you'll see some text I added to try and further explain what I'm talking about.
(I know many of you could probably do this in your sleep, but I don't know where to start...)
Thanks in advance if anyone can help!
Bookmarks