Hi all,
I’m trying to sort a large amount of data where over a year events
occur a given period (fortnight) but that event is not necessarily
input within the given period.

This formula gives me all of the events where C5 contains the start
date of the period, D5 contains the end date of the period, and the
‘DATE’ range contains the actual event date:

{=SUM(('D District Date Sort 2003-4.xls'!Date=$C5)*('D District Date
Sort 2003-4.xls'!Date<=$D5)}

What I thought I could do if have another condition *('D District Date
Sort 2003-4.xls'!Date_Entered$D5)) where ‘Date_Entered’ range is when
the event was input onto the system – but it doesn’t work!

Any ideas please?

Thanks

Robert


--
RobPot
------------------------------------------------------------------------
RobPot's Profile: http://www.excelforum.com/member.php...o&userid=18721
View this thread: http://www.excelforum.com/showthread...hreadid=390876

On Thu, 28 Jul 2005 04:26:05 -0500, RobPot
wrote:


Hi all,
I’m trying to sort a large amount of data where over a year events
occur a given period (fortnight) but that event is not necessarily
input within the given period.

This formula gives me all of the events where C5 contains the start
date of the period, D5 contains the end date of the period, and the
‘DATE’ range contains the actual event date:

{=SUM(('D District Date Sort 2003-4.xls'!Date=$C5)*('D District Date
Sort 2003-4.xls'!Date<=$D5)}

What I thought I could do if have another condition *('D District Date
Sort 2003-4.xls'!Date_Entered$D5)) where ‘Date_Entered’ range is when
the event was input onto the system – but it doesn’t work!

Any ideas please?

Thanks

Robert

Does it result in an error, or an just a wrong value?



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Well done Richard!

I think it does work - my 'Date_Entered' range was incorrect.

Thanks for that!


--
RobPot
------------------------------------------------------------------------
RobPot's Profile: http://www.excelforum.com/member.php...o&userid=18721
View this thread: http://www.excelforum.com/showthread...hreadid=390876