Hi Pedro my cells are not in consective order so that is why I did + sign. I get 11 08 11 when I use : any other suggestions. Scott
-----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Pedro Romero Sent: Saturday, March 01, 2014 4:28 PM To: [email protected] Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula Hi Scott. Here is what works for me. I am using Excel 2007. If I want to add the sum of cells K1 through K5, do the following. =sum(k1:k5) Note: it may help to read this formula character by character to hear where the colons and parentheses are. Hope this helps. Pete ----- Original Message ----- From: "Scott Meyer" <[email protected]> To: <[email protected]> Sent: Saturday, March 01, 2014 1:11 PM Subject: [JAWS-Users] 2007 Microsoft Excel Questions about formula > Hi > trying to add 3 colums put in =Sum(H2 +k2+L2) and I get #value in cell > also want to put a number that is in a colum in another colum put > =Sum(M2)That just showed the formula.What am I doing wrong? > regards > Scott > > > For answers to frequently asked questions about this list visit: > http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
