| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumProd from 2 columns and date range
That did it.
Thanks for the help. "Max" wrote: A1: 1/1/2009 A2: 10/1/2009 A6: 54976 You need to amend the enddate in A2 to read as: 11/1/2009 (ie the 1st of the "next" month), then use this: =SUMPRODUCT((Overall!H8:H3000=A1)*(Overall!H8:H30 00<A2)*(ISNUMBER(SEARCH(A6,Overall!F8:F3000)))) Above will apply the date range criteria of dates from 1 Jan 2009 till end Oct 2009. (The "<" in "<A2" is intentional) -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "roy.okinawa" wrote in message ... Max, Yes I want it for certain date ranges. In my OP I put Oct 09, etc. I meant to use 1/1/09. So my input cells would be (all dates that fall between that criteria need to be totaled: The above date criteria (A1, A2) and part number (A6) are looking for the total count of the part number that matches against Overall worksheet columns H (date)and F (part number). I tried your formula but it totals for some: 3 years worth instead of current year 2009 dates and no totals for others. Thanks for the assistance. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating columns based on date range | Excel Worksheet Functions | |||
| SUMPROD question | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| extract data from a range of cells in rows or columns when a date. | Excel Worksheet Functions | |||
Hybrid Mode
