# Exclude cells from cumulative sum [closed]

Hi Libreoffice users,

This is a simple version of my spreadsheet in Libreoffice Calc : http://i.imgur.com/bgOTpWf.png

The C column starts with the formula =SUM($B$1:$B1) and the second one is =SUM($B$1:$B2) and so on, to calculate the cumulative sum of row B. Now I would like to automatically exclude the total cells from row C. (Because my own spreadsheet is really long)

Thanks in advance!

Version: LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) OS: Debian Wheezy