ExcelFilter: Between Day 1 and Day 90, I had how many of which?
September 2, 2009 7:09 AM Subscribe
How can I count certain things in a range of cells in Excel that fall between two dates?
posted by SansPoint to computers & internet (5 answers total) 2 users marked this as a favorite
I've got an Excel workbook that keeps track of every thing I produce at my job. (What the things are is irrelevant.) The date it's created in in Column A. In Column F there are criteria to determine which type of thing is is (two specific ones). I would like to count the number of each that fall between two dates, i.e. between, say 9/01/2009 and 11/30/2009.
For the life of me, I can't figger it out.
I've tried wrapping my head around dynamic ranges, but all I can see for doing that is OFFSET(), which would be great if all the date ranges had the same amount of rows, but they don't. Besides, I add new rows to this thing regularly, as each new thingie is generated. So, having, say, the last 30 of these counted does not help.
Google searching has given me info about how to count for the last x of a certain range, where x is days, weeks, months, etc. Doesn't help.
Oh, and I *really* would not like to have to go into VBA scripting for this.
So, uh, help?