Estimating monthly totals from overlapping period between years

[pminamdar]

Hello All,

Pardon if my question is already posted.

I have a daily time series of flow volumes at 37 sites ( 37 columns) between 2004 to 2016. I need a monthly sum between summer months (September to March) throughout entire period.
For example, a monthly total from September 2004 to March 2005.

I have created a pivot table which provides me monthly sums per year. However, I am struggling to get summer totals between years (04/05, 05/06, and so on).

Is there any easy way of doing this?

Thanks.

 

[jarjarbingie]

Hello All,

Pardon if my question is already posted.

I have a daily time series of flow volumes at 37 sites ( 37 columns) between 2004 to 2016. I need a monthly sum between summer months (September to March) throughout entire period.
For example, a monthly total from September 2004 to March 2005.

I have created a pivot table which provides me monthly sums per year. However, I am struggling to get summer totals between years (04/05, 05/06, and so on).

Is there any easy way of doing this?

Thanks.

assuming the dates are in column A, let's add a helper column, let's call it Summer Year using this formula:

=IF(MONTH($A2)<=3,YEAR($A2)-1,IF(MONTH($A2)>=9,YEAR($A2),""))

then drag this field into the pivot table..

for Summer Year = 2014, that should be from 9/1/2004 to 3/31/2005

 

[pminamdar]

Thank you so much for your kind help. This solves my problem.