Convert Monthly to Quaterly timeline

  • Thread starter Thread starter James
  • Start date Start date
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
 
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

Converting Monthly figures to Quarters 1
1st of current quater today() 5
Convert monthly data into quarterly data? 2
Sum months into quarters? 3
subtotal within subtotal 5
Copying formula to sum multiple columns 3
Formatting help desperately needed 2
Still trying to average 4 worksheets and having formula problems 3

Back
Top