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
 
Top