Cumulative sum of different cells on different sheets

I currently have various data in several columns of cells which are categorised by month, eg:

Jan xxxx 1111
Feb yyyy 2222
Mar zzzz 3333...

I need to sum up these amounts on a different worksheet cumulatively, ie. Jan, Feb (Jan + Feb), Mar (Jan + Feb + Mar), etc..

Is there any formula i can use to do this, which can be dragged out on the 2nd worksheet to speed things up? I am currently clicking indiv cells to sum them up and it is taking a REALLY long time (I have 5 years of data I need to do!)

Please help!

you can use SUMIF funtion

for exampe
Feb --> =SUMIF(MONTH(data!$A$2:$A$100),"<=2",data!$C$2:$C$100)
Mar --> =SUMIF(MONTH(data!$A$2:$A$100),"<=3",data!$C$2:$C$100)
...
and so on..

Hi, thanks for the quick response. Unfortunately, =sumif won't work for a different worksheet right?

I'll try to clarify, the months (Jan 08, Feb 08, etc) are merely text cells, and in the column NEXT to it (ie not part of the same cell), there are various data I require to be summed up.

Eg: (|:stands for column break)

Toyota Ford VW
Jan 08 | 109,966 | 1,223,864 | 345,966
Feb 08 | 555,163 | 553,313 | 557,111

On a different in a different workbook, I need to compile the data as such:

Jan 08 Feb 08 (jan+feb 08) Mar 08 (jan+feb+mar)
Toyota | 109,966 | 109,966 + 555,163 |
Ford | etc
VW |
________________________________________________________________

Hope this was clearer.

In addition, could I find out how I can fix values that are linked to another worksheet? E.g. If the 109,966 above is derived from the addition of other figures in another worksheet, is there any way I can save the worksheet i'm working with as is to 'fix' the numerical values onto that so i don't need to depend on the other worksheet?

Have uploaded an example. Really, REALLY appreciate help on this!

It is, in fact, a different workbook.

Therefore, daily data is compiled to give monthly data ("Raw Data" in my .xls example), which is in the same workbook. In a different workbook, I need to collate a cumulative sum (across months) of all the data by Products, as seen in the lower half of my example

btw, I managed to solve the problem of breaking the link between the 'raw data' and the final pdt. after making the links, I copied the original worksheet and transferred it to the workbook with the compiled data. Then, I Ctrl + R and replaced the original sheet name from "'YTD''08 JGH''s HQ " to 'YTD''08 JGH''s HQ (2)'. All my links seem to be working fine in the new workbook, so will appreciate any comments on this method of 'breaking' the links as well

hmm would you happen to know how I could break the links from a worksheet in one workbook to another? i just need the raw data (numerical values), which is in Worksheet A in Workbook 1, but the info is linked to multiple worksheets in Workbook 2. Any suggestions?

Hi,

I have created another example of what I'm talking about, with worksheets more similar to what I really need. Any help appreciated!

(Yes, i DO have to fill up the whole sheet, hence my seeking help because as you can see from the row I have included, I am manually adding cells to get the cumulative total)

Unfortunately I am completely unfamiliar with VBA. Wrt doing it seperately by regions, how would I go about doing it? As you can tell, the main 2 things I need to do is:

convert data in column form to row form, and accumulate this data 'to date' (Feb = Jan + Feb), and so on.

links- thanks! I actually managed to find Edit > Links > Break links for the whole document. This will work without affecting anything right?