|
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.
.
|