LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 122
Default SUMPRODUCT to return date of last payment?

Can I use SUMPRODUCT to return the date and amount of last payment if
I provide the account number?

Column A is Date mm/dd/yyyy
Column B is account number (numeric 6 digits)
Column C is type: PMNT, Purchase
Column D is amount, either a + or - based on Mayment or Purchase
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting payment when increase rate is known & total payment is kn Shailendra Harri Excel Worksheet Functions 12 September 22nd 07 09:04 PM
set payment date 28 days after following friday rhydim Excel Discussion (Misc queries) 3 August 22nd 06 12:23 PM
calculate payment with first payment due date variable? Jody Solbach Excel Worksheet Functions 1 September 8th 05 05:46 PM
pmt function in Excel does not return correct monthly payment amou Harraman@Bangalore Excel Worksheet Functions 6 March 3rd 05 01:28 PM
how do you get a positive number payment with a mortgage payment . sam Excel Worksheet Functions 1 February 2nd 05 05:32 AM


All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"