DSUM not working...?

[webbeacon]

Hi Everyone,

I'm using the following:

=DSUM(INDIRECT('Team List'!A2&"!$A$2:$d$100"),"Duration",$AN$3:$AO$4)

where 'Team List'!A2&"!$A$2:$d$100 results in the following data:

Date		Start	End	Duration
1/12/2008	13:00	14:00	1:00
1/13/2008	13:00	14:00	1:00
1/14/2008	13:00	14:00	1:00
1/15/2008	13:00	14:00	1:00
1/16/2008	13:00	14:00	1:00

and $AN$3:$AO$4 contains:

Date		Date
>12/31/2008	<02/01/2009

I'm at a complete loss right now... this was all working smashingly last time I looked at it and now it doesn't work at all. The duration is supposed to calculate based on the month and give me a running total, but it just shows 0:00 hours. I think the only change i might have made since it was working is to protect the worksheets. I've unprotected them and it still not working. Anyone have some idea why?

Thanks a million,
Jen

 

[Aladin Akyurek]

What do you have in:

'Team List'!A2

 

[webbeacon]

Cell A2 on Team List tab contains the number 1, which then points to a tab named 1. This tab (and others also named numerically) contains the data "Date; Start; End; Duration" that is referred to later in the DSUM.

 

[webbeacon]

I've resolved the problem, and (not surprisingly) it was user error. My date ranges are for 2009 and the dates I entered were 2008.

/sigh

sorry for wasting your time, but thank you for the quick response!!!