SumProduct Woe's

**jcastellano** · 03-14-2006, 08:51 AM

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

**davesexcel** · 03-14-2006, 09:04 AM

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