Sum in Range.....

[Cordury]

Good Morning,
On Sheet1 there are two columns one has the date and the other contains amounts. There is an amount for every business day for the last 3 years (Example below):

Column A Column B
2/1/2003 322.5
2/2/2003 445.2
2/3/2003 299.6



I would like to be able to sume the amounts by accounting periods on Sheet2 which would be the beginning of another analysis but I want to condense space by showing just the start date and the end date of each month with the sum of the amount on column C (Example Belw)

Column A Column B Column C
2/1/2003 2/28/2003 10,000

Any ideas would be appreciated.
Thank you,

 

[Cordury]

Below is the formula I have entered that is not returning the correct data.

=SUMPRODUCT(('US Input'!A2:A1044>='Seasonal Adjustment'!B4)*('US Input'!A2:A1044<='Seasonal Adjustment'!C4),'US Input'!F2:F1044)

US Input Sheet Column A contains the days of the year.
US Input Sheet Column F contains the amount of the invoice.
Seasonal Adjustment Sheet B4 contains the Start date.
Seasonal Adjustment Sheet C4contains the End date.

I would like to be able to sum the invoice amounts from US Input Sheet in the Seasonal Adjustment Sheet by just adding the start and end date of the month.

 

[Cordury]

Thanks for all the help but I got it figured out.

SUMPRODUCT(('sheet1'!$A$1:$A$1200>=A1)*('sheet1'!$A$1:$A$1200<=B1),'sheet1'!$B$1:$b$1200)