Database

[paulrm906]

I have in colmn 1 dates in sequence and in colmn to 2 I have numbers can
someone please tell me a formula for example where I can extract data
from colmn 2 for example from the 1st Oct 05 to the 15th Oct 05. Many
thanks if you could help me. Paul Maynard


--
paulrm906

[Roger Govier]

Hi Paul

One way
=SUMPRODUCT(--($A$1:$A$100>=DATE(2005,10,1)),--($A$1:$A$100<=DATE(2005,10,15)),$B$1:$B$100)
Change ranges to suit, but ensure that they are of equal size.

Regards

Roger Govier


paulrm906 wrote:
> I have in colmn 1 dates in sequence and in colmn to 2 I have numbers can
> someone please tell me a formula for example where I can extract data
> from colmn 2 for example from the 1st Oct 05 to the 15th Oct 05. Many
> thanks if you could help me. Paul Maynard
>
>