HiI hope this is what you want - to add the contents of cells a1 through a9 use the formula=sum(a1:a9).
regards david----- Original Message ----- From: "Robin" <rob.wrj@xxxxxxxxxxxx>
To: <access-uk@xxxxxxxxxxxxx> Sent: Thursday, April 22, 2010 10:03 AM Subject: [access-uk] Xl formula
Could anyone tel me what is the formula for adding subtotals in a colum in xl. As simple as possible please. Many thanks. Cheers Robin. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Stupidity does not qualify as a handicap, park elsewhere! ** 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__________ Information from ESET Smart Security, version of virus signature database 5048 (20100421) __________The message was checked by ESET Smart Security. http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 5049 (20100422) __________ The message was checked by ESET Smart Security. http://www.eset.com ** 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