Hi Pele Ok thanks for this but how do I get it to see that the first sum to start adding is in b138 and not c138 unless I put the figure in c138? And no I don't have a column to say that the month has changed, it is just one long Colum. Regards Adrien -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Pele West Sent: Monday, June 20, 2011 4:10 PM To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Help with an excel formula please Hi Adrien I can answer the first part of your question, I think. You can put a formula in Column C =sum($b$138:b139) Put this in C139 then copy it to all the columns up to C711. The $ sign means it will always start adding from B138. As for totalling for each month, do you have a column to show that the month has changed? Pele West ** 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 15 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