Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Last Occurrence of Number | Excel Discussion (Misc queries) | |||
Need help on Excel formula to find an occurrence and display numbers | Excel Worksheet Functions | |||
How to find SECOND occurrence in a string? | Excel Worksheet Functions | |||
Find nth occurrence and replace with ":" | Excel Worksheet Functions | |||
find last occurrence | Excel Worksheet Functions |