This is my second attempt - for some reason my first attempt failed to create a new thread.


I have a data set (col. A-U) and I am trying to count the number of records that meet the following criteria for each month in 2012. Some records might be included for each month of the year, some may only be included in the totals for Jan-Jun, etc. The criteria for counting a record are as follows:
col. M = "text"
col. B (date) </= (i.e. is earlier than) "Jan-2012," "Feb-2012," etc.
col. C (date) < "Jan-2012," "Feb-2012," etc.
col D (date/text) < "Jan-2012," "Feb-2012," etc. OR Is Blank

The output would (ideally) look something like this:

Jan-2012 Feb-2012 Mar-2012 Apr-2012 May-2012...
49 49 51 53 48

I hope my question makes sense. Thanks in advance for any assistance!