2014-05-26 17:56 GMT+02:00 Hannes <han...@sacramentospur.co.za>: > Hi guys > > My “sum” etc calc functions are’nt working. If you want to , for example , > add the values of say column A1 to A5 , it just says “=A1:A5” , but does’nt > do the culculation ? > > Kind regards >
You said that your ”sum” function doesn't work, but how do you know? As far as I can see, you don't use it… This is how to use the SUM function for A1:A5: =SUM(A1:A5) If it now displays the formula rather than the result, check ”Tools → Options” for something like ”show formulas” and uncheck it. Johnny Rosenberg > > HANNES ROOS (Owner/Operator) SACRAMENTO SPUR > C/o Heinrich & Madelief ave, Karenpark , Pretoria-North, Tel: 012-5492274/5 > • Fax:012-549-2276 > • Cell: 0823263122 • Email:han...@sacramentospur.co.za > Postal Address: P.O. Box 58756,Karenpark,0118,Pretoria > > --- > This email is free from viruses and malware because avast! Antivirus > protection is active. > http://www.avast.com >