Based on the OP's explanation:
>Column L22:L29 is titled -Weeks- - Each row is broken down by week
>L22/8/17/05, L23 8/24/05. L24 8/31/05, etc to L29 10/5/05
So, N22 is the first formula cell:
>N22 = SUMPRODUCT(--('Worksheet B'!J$2:J$528>=L22),--('Worksheet
>B'!J$2:J$528<L23)) (Copy down)
Your formula uses the next cell to set the upper boundry in the date range.
When you copy this down to N29 that formula would look like this:
=SUMPRODUCT(--('Worksheet B'!J$2:J$528>=L29),--('WorksheetB'!J$2:J$528<L30))
L30 is outside the date range of L22:L29. So, if L30 is an empty cell it
evaluates to zero and the Sumproduct formula evaluates to:
--('WorksheetB'!J$2:J$528<0)
If you only copy the formula to cell N28 then you don't account for dates
>=L29.
Biff
"Morrigan" <
[email protected]> wrote in
message news:
[email protected]...
>
> I still do not understand what you mean. Can you explain a little
> more?
>
>
> Biff Wrote:
>> N29 is a formula cell and has nothing to do with any count.
>>
>> Test it and you'll see what I mean.
>>
>> Biff
>
>
> --
> Morrigan
> ------------------------------------------------------------------------
> Morrigan's Profile:
> http://www.excelforum.com/member.php...fo&userid=7094
> View this thread: http://www.excelforum.com/showthread...hreadid=400958
>
Bookmarks