Hi I keep a spreadsheet of how much we spend, in the spreadsheet I have a column for the date and then the amount. I have worked it strangely, the top part of the spreadsheet is the credits so the bit I need help with starts further down. The first transaction is on b138 and the last one is on b711. I have a cell below them to give the total from b138 to b711 but what I would like to do is in Colum c from c138 to c711 make excel add the next row to the previous one so as I go down it shows me the total of b138 plus b139 etc, a running total. how can I do this and when I put another amount in 712, it automatically fills in c712. also I would like to put a formula in column d at the end of each month, the total for the month, I have been doing it manually, adding for example b138 to b150 which may give me the total for the month. Regards Adrien -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 8 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq