Convert Monthly to Quaterly timeline

J

James

Hello

I have a cashflow that is currenlty in monthly units - i want to convert
this to quarterly units and sum the results for each fo the three months into
each quarter.
Does anyo0ne know the best way ot do this?

THanks
 
B

Bernie Deitrick

If you have actual dates, then use a pivot table and group the values by quarter.

Or, if not, then use SUM (?)

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crate Table Query - Closest to the 15th day..... 0
Convert PDF to Visio File or Editable PDF in Visio 0
Create timeline with event being hyperlinks to documents on drive 1
Convert monthly data into quarterly data? 2
Changing Monthly Data to Daily Data? 1
Linking Child Timelines to Multiple Parents 0
Copying formula to sum multiple columns 3
convert text to values 7

Top