SUMPRODUCT Loop Question

**dash11** · 04-10-2012, 05:18 PM

Good afternoon. This is my first time posting a question so please bare with me. I'm using a SUMPRODUCT in a vba code. I'm trying to loop it across a row of cells, changing the sumproduct range nested within as it moves along. Example:
=SUMPRODUCT((Timeline!$C$3:$C$10000>DATEVALUE("12/31/2010"))*(Timeline!$C$3:$C$10000<DATEVALUE("02/01/2011")))
I'm wanting the date value to move up a month in both instances as it loops across the row. Again, I apologize if this is in any way vague but any assistance is GREATLY appreciated.

From the spreadsheet attached, I'm doing a sumproduct from the Timeline tab.

**Bob Phillips** · 04-10-2012, 05:25 PM

How big is the loop, start and end cells? Is your example the first one, and are the dates to move along stored anywhere on the sheet?

**dash11** · 04-10-2012, 05:33 PM

The lookup to the "Timeline" is a data tab that contains a range of dates that I'm trying to do a sumproduct of. I'm not sure what is meant by "how big is the loop" but the sumproduct formula will move along a row for 12 months. For example, my January sumproduct result will be from the example above being a Datevalue between 12/31/10 and 2/01/11 (January 2011). Then for the next column over (February 2011), I will need the date parameters to both move over one month.

SUMPRODUCT Loop Question

LinkBack

Thread Tools

Rate This Thread

Display

SUMPRODUCT Loop Question

Re: SUMPRODUCT Loop Question

Re: SUMPRODUCT Loop Question

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions