Hi pedro still get a date in cell, copied your formula and just changed reference cells. a mystery. Thanks Scott
-----Original Message----- From: JAWS-Users-List [mailto:[email protected]] On Behalf Of Pedro Romero Sent: Saturday, March 01, 2014 5:41 PM To: [email protected] Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula If you want to add nonconsecutive cells you might try this. I just did it and it worked. =SUM(A1,A3,A5) Pete ----- Original Message ----- From: "Scott Meyer" <[email protected]> To: <[email protected]> Sent: Saturday, March 01, 2014 2:35 PM Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula > 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/ Hope this works. Pete 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/
