Hi Pele Don't worry, your formula worked for me. Thanks. It is always hard understanding something if you haven't done it before. Take care. Regards Adrien -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Pele West Sent: Tuesday, June 21, 2011 12:02 AM To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Help with an excel formula please Hi Adrien I am not sure I understand your question. If you put the formula in C139 using $b$138 as your starting point, it should work. If, at the start of each month, you put a formula in, say Column D, you should be able to total the figures for that month. For example, suppose your figures for June started in Column B400. When you entered the second amount in Column B401 put a formula in D401: =sum($d$400:d401) and copy it to all the rows for that month. I don't know if there is a list of useful formulae anywhere. I spend quite a lot of time using Google to find out what I want to know. Pele ** 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 -- I am using the free version of SPAMfighter. We are a community of 7 million users fighting spam. SPAMfighter has removed 27 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