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? |
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 |