Matthew Kelley
New Member
- Joined
- Jun 5, 2015
- Messages
- 5
I am new to the forum and I need technical help desperately. I need a formula to deal with 3 columns of data all on the same row on my financial spreadsheet. Column E contains dates of receiving interest income entered in this way "5/30/2014". Column F contains the interest earned amounts entered in this way "$25". I need a formula that duplicates my interest income data($25) from F to column L which is interest payments received in 2014. The formula needs to recognize the 2014 from the date and automatically put my gain into column L. The formula needs to ignore and NOT duplicate negative values from F into column L.
If someone here has the solution I would be so grateful.
If someone here has the solution I would be so grateful.