Moving Annual Total

**skate1991** · 02-22-2012, 05:49 AM

Hi

I was just wondering if anyone could help me with this problem,

I wanted to know if there is a formula to work out yearly moving total for example

If Column A is dated "1 Jan 2010" then the Moving Annual Total would be the sum of customers from "1 Jan 2010" to "31 Dec 2010". And the next would be 1 Feb 2010 to 31stJan 2011

I’m going to have to do this for 50 customers so I was just wondering if there was a formula to cut down on time, I will also be putting these into graphs, so any help with that would be good

I have attached an example worksheet

Thanks

**martindwilson** · 02-22-2012, 06:28 AM

on way in d1
=SUM(B1:INDEX($B:$B,11+ROW(A1))) dragged down
or
=SUM(OFFSET(B1,0,,12))

**iamapharmacist** · 03-05-2013, 01:45 PM

can you advice me for the same issue if the data is just entered in one row not in column

**martindwilson** · 03-05-2013, 01:58 PM

Welcome to the Forumb.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.