Monthly to Quarterly Cash Flows

Hi There

I am building a Discounted Cash Flow.

I have monthly cash flows rolling for 10 years, which I need to sum up into quarterly cash flows.

Can someone please give me some direction as to the best function to use?

Thanks,

Hi,

You can add a new column called "Quarter" into the database (if it is not there) and run a Pivot Table to get the desired result.

Q3-2013, Q1-2014, Q2-2014 etc.