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
|