Convert Monthly to Quaterly timeline

[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

 

[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