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
 
Back
Top