| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date and amount of last payment
Can anyone help me with a sumproduct question?
I have on sheet 1 columns with Date, Account, Amount in columns A, B, C On sheet 2, in A1 I have an account number field that can be changed. I need a sumproduct formula to return the date of last payment for that account and in another cell, return the amount of the last payment. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find the loan amount from my payment in Excel? | Excel Discussion (Misc queries) | |||
| How to change scheduled payment amount in Excel | Excel Worksheet Functions | |||
| calculate payment with first payment due date variable? | Excel Worksheet Functions | |||
| Calculating number of periods when payment amount changes | Excel Worksheet Functions | |||
| I need a loan calculator that you can plug in the payment amount | Excel Discussion (Misc queries) | |||
Threaded Mode
