SumProduct Woe's
 

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.


:confused:

John


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

SumProduct Woe's
 

You can zip your example and then attach it, then maybe more will look
at it:
goto the directory you have the workbook saved, right click on the
file, send to, compressed folder, it is now zipped, attach that zipped
file to your message, Cheers


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

SumProduct Woe's
 

I have now attached a zip file. This is a one page example in PDF
format.

Please help.


John


+-------------------------------------------------------------------+
|Filename: SumProduct Table.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4452 |
+-------------------------------------------------------------------+

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

SumProduct Woe's
 

Zip the workbook example, not the pdf


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

SumProduct Woe's
 

I've posted the zip Excel file.


+-------------------------------------------------------------------+
|Filename: SumProduct Table.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4460 |
+-------------------------------------------------------------------+

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