# Excel – How to add all previous cells to a cell using a function in Microsoft Excel

microsoft excelworksheet-function

If I have a column:

0 |

1 |

2 |

3 |

4 |

I would like for in the column on the right to take a cell on the left and add all previous cells to it. So that it looks like the two columns below:

0 | 0

1 | 1

2 | 3

3 | 6

4 | 10

I've tried manually adding each but I know there must be a function that can accomplish this. Thank you.

=SUM(A\$1:A1)