I have been having a difficult time getting a response to this issue I
am having. Hopefully, I can do a better job of explaining the
problem.

I am having my plants forecast weekly receipts and disbursements for an
18 week period time once a month (i.e. every 15th of the month each
plant will provide a new 18-week forecast). Each week's forecast will
be in one separate column beginning in column f (i.e. 24-Feb column f;
3-Mar column g;10-Mar column h; etc.). Therefore, after the next
monthly update, column f will be week #1 of the forecast but it will be
a different week ending.

In column c I have several categories of receipts and disbursements for
which I will receive a forecast. My deliverable to my banks only needs
to be 13 weeks, but I have to produce the deliverable weekly.
Additionally, I also want to summarize some of the categories in column
c as I will not need to show all of the detail. Therefore, my first
deliverable would begin with the week of 24-Feb in column f and go
through 19-May in column r. The following week, my deliverable would
begin with 3-Mar in column f and go through May 26 in column r. Do you
see the pattern?

In column e I have created summary categories for the line items I have
in column c. I have been trying to use the sumproduct category as I
want to summarize by my categories in column e, yet I want to go to the
source table based on the week ending dates I have in each column
header. I have discovered that sumproduct will not work with different
arrays. I posted a thread last night with a pdf sample of what I am
trying to do and I have no response. I don't know if that's due to the
fact that there is a file attached to the thread and users are concerned
about viruses, or if I am trying to do something crazy here.

I hope someone can help. Very desparate.




John


--
jcastellano
------------------------------------------------------------------------
jcastellano's Profile: http://www.excelforum.com/member.php...o&userid=30986
View this thread: http://www.excelforum.com/showthread...hreadid=522136