Or you can also enter something like this: =sum(B2:B9) and it will add
whatever is from B2 through B9 including those two cells.
---
Be positive! When it comes to being defeated, if you think you're finished,
you! really! are! finished!
----- Original Message -----
From: "Greg Washington" <[email protected]>
To: <[email protected]>
Sent: Saturday, March 01, 2014 6:28 PM
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Scott,
I am using Excel 2007 on a windows 7 64 bit computer with Jaws 13. When I
want to add rows or columns I simply enter a formula such as =b2+b7+b9 and
it works fine for me.
HTH
Greg Washington
-----Original Message-----
From: JAWS-Users-List [mailto:[email protected]] On
Behalf Of Scott Meyer
Sent: Saturday, March 01, 2014 5:42 PM
To: [email protected]
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
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/
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/
