Formula in one sheet to find first occurrence of date in another
 

I have an Excel file that contains one spreadsheet containing dates
and payments, and a second statistical spreadsheet that contains
monthly totals. The totals are to be referenced by from and to dates
(i.e. start and end of each month), and I want a formula in the third
(total) cell that is the sum of all the payments appearing in the
first sheet between the from and to date.

Could someone please help?

Formula in one sheet to find first occurrence of date in another
 

Hi
You could use SUMPRODUCT eg:
=SUMPRODUCT((Sheet1!C2:C500=DATEVALUE("01/04/2008"))*(Sheet1!C2:C500<=DATEVALUE("30/04/2008"))*(Sheet1!B2:B500))

Where dates would be in range C2 to C500 Sheet1 and Amounts in range B2 to
B500 Sheet1

Please amend accordingly (especially date formats and ranges)

HTH
Cordially
Pascal


"Simple Simon" a écrit dans le message de news:
...
I have an Excel file that contains one spreadsheet containing dates
and payments, and a second statistical spreadsheet that contains
monthly totals. The totals are to be referenced by from and to dates
(i.e. start and end of each month), and I want a formula in the third
(total) cell that is the sum of all the payments appearing in the
first sheet between the from and to date.

Could someone please help?