Hi,
I am currently working in a file that I am going to post a sample of. My problem is that I need a count of cars by ID# given a certain time period. So in order to set the date range I am using the formula =SUMPRODUCT((Sheet2!A:A>=$A$1)*(Sheet2!A:A<=EOMONTH($A$1,0))). Where A1 is August 2014.
When I run this formula I get 9, which the correct number of instances that August 2014 is listed on my date list in Sheet2. After this I need a sum of Column C in sheet2 based off the ID# in sheet 1.
Sorry if my explanation is not very good. Sample Problem.xlsxI have attached a sample. Please let me know if there are questions and I can clarify as best as I can.
Thanks!!
Jacob
Bookmarks