COUNTIF / SUM problem

[RobPot]

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

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

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

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

Any ideas please?

Thanks

Rober

 

[Richard Buttrey]

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
__________________________

 

[RobPot]

Well done Richard!

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

Thanks for that!