>I would like to use the SUMIF function in Excel '97 to return amounts
>from a range which correspond to dates between two given dates.
>
>For example, I would like to develop a formula to return all the amounts
>between 30/6/97 and 31/12/97 in the table below (the answer here is
>825):
>
>Date Amount
>
>15/6/97 100
>28/6/97 150
>18/7/97 320
>24/9/97 80
>14/11/97 190
>25/12/97 85
>6/1/98 150
>
>
> I've tried using SUMIF to do this, but it only seems to take criteria
>which relate to one date (i.e > 30/6/97) rather than two dates (e.g
>>30/6/97 and <31/12/97).
>
>I would be very grateful for any help or suggestions which could help me
>solve this problem.
>
>Peter Montgomery



I use array formulas for getting these answers

ex:
{=sum(if((a1:a100>date1)*(a1:a100