Sumproduct formula problems - help!

[dkballs]

Please help.

I have a workbook that i am having trouble with. In the first sheet (called "control sheet") i have input some radio buttons that when pressed change the value of a cell to reflect changes in dates. for example Period 1 button date range of B17 would equal 17/04/2011 and C17 would equal 14/05/2011 (end of the period). There are 13 buttons each changing the value of B17 and C17 to reflect the start end of each period.

I then have a second sheet called "bakery". In the bakery sheet there are employee names in column A and an associated date in column B.

Essentially i need a cell in "bakery" to tell me how many dates there are inbetween the start date and end date of each period (displayed on "control sheet").

I have tried the following formual but it doesn't work...

=SUMPRODUCT((B6:B44>'Control Sheet'!B17)*(B6:B44<'Control Sheet'!C17))

Any ideas greatly appreciated...

 

[Dave Patton]

Please clarify specifically your comment
"I have tried the following formual but it doesn't work..."

The formula looks like it should yield the count.

You could try Countif
=COUNTIF(B6:B44,">"&'Control Sheet'!B17)-COUNTIF(B6:B44,">"&'Control Sheet'!C17)

or
=SUMPRODUCT(--(B6:B44>'Control Sheet'!B17),--(B6:B44<'Control Sheet'!C17))

Excel's Evaluate Formula may help you isolate the problem.