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