Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Pick up a cash flow line from a specific date

Hi!

I have an income line A that start at Sept 2018 (quarterly cf) and I have a consolidated cash flow that starts in Sept 2012. I'm trying to find a formula that enables the consolidated cash flow line to automatically pick up income line A when the consolidated cash flow reaches sept 2018. The problem that I'm faced with is that Income line A is a stream of income, i.e. from sept 2018 and onwards the consolidated cash flow should report the income line A.

I've tried sumif and if but I must be doing something wrong.

Can anyone help me with this?

Thanks

H
Reply
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
How do I sum cashflows within date range given dates and cash flow Gerry Pat Excel Worksheet Functions 1 April 22nd 08 08:51 PM
Cash Flow Lindy-Jane Charts and Charting in Excel 1 November 28th 06 02:19 PM
Cash Flow Omalley Excel Discussion (Misc queries) 2 July 28th 05 01:16 PM
Cash Flow [email protected] Excel Programming 1 July 27th 05 06:19 PM
Cash Flow Set-Up Gary T Excel Worksheet Functions 0 January 13th 05 05:07 PM


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

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

About Us

"It's about Microsoft Excel"