Hi Pedro Thanks. Scott -----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Pedro Romero Sent: Saturday, March 01, 2014 5:02 PM To: [email protected] Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Sorry! I didn't realize that the cells were not in consecutive order. If I can figure out how to add non-contiguous cells or columns, I'll be sure to let you know. Take care. Pete ----- Original Message ----- From: "Scott Meyer" <[email protected]> To: <[email protected]> Sent: Saturday, March 01, 2014 1:48 PM Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula > 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/ 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/
