Rangesum over more than 1 column

[#1]

Hi,

Is there anyway to do a rangesum over more than one column.

For example.

Pivot table with Year, Quarter, Month and Rate

Want to be able to show month1 rate = month1 Rate, Month2 = Month1+ Month2 etc

Rangesum works fine up to Month3, then Quarter changes to Q2 and the sum starts again. I want to be able to add Month3 rate +Month4 rate.

Any help would be great.

Thanks