I have a frequency table and I am looking to add a cumulative frequency column to it. The first 5 rows of the table looks like this:

Type Freq

1 1201

2 3910

3 2191

4 3654

5 9822

I just want to add a cumulative frequency column to the right. I did my research and attempting the following:

Assume the first Type value is in cell A2. I created a column called Cumulative Frequency, and then in cell C2 I wrote '=A2'. In cell C3 I wrote '=A2 + A3' and in cell C4 I wrote '=A2 + A3 + A4'. I then selected the cells C2:C4 and dragged the bottom right corner to the bottom.

However, instead of Excel understanding that I was creating a Cumulative Frequency column, it simply copied similarly what I had already wrote.

C5 = A5

C6 = A5 + A6

C7 = A5 + A6 + A7

C8 = A8

etc.

Any idea how I can fix this? It's a table of around 300 rows so I don't want to type the formulas individually.

## Best Answer

Use SUM() with a variable range:

Note what is relative. As this is dragged/copied down the row number in the

`$A2`

will change always summing the range above.