You are right. If you copy formula to cell N28 then you do not count
L29, which I think you should not. L29 should be consider as the first
day of next week. If you count L29 you will have 8 days in that week
which I think is wrong.



Biff Wrote:
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"
wrote in
message ...

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



--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=400958