, 2014 10:34 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Also, it is not CTRL+F1 as I mistakenly typed. It is CTRL+1 that brings up
the formatting dialog box.
Take care.
Brian Lee
brianl...@charter.net
-Original Message
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:
Message -
From: Scott Meyer scottt.me...@verizon.net
To: jaws-users-list@jaws-users.com
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
...@gatewayfortheblind.com
-Original Message-
From: Scott Meyer
Sent: Saturday, March 01, 2014 3:11 PM
To: jaws-users-list@jaws-users.com
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
.
---
Be positive! When it comes to being defeated, if you think you're finished,
you! really! are! finished!
- Original Message -
From: Scott Meyer scottt.me...@verizon.net
To: jaws-users-list@jaws-users.com
Sent: Saturday, March 01, 2014 3:11 PM
Subject: [JAWS-Users] 2007 Microsoft Excel
To: jaws-users-list@jaws-users.com
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
: 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
Hi Pedro
Thanks.
Scott
-Original Message-
From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On
Behalf Of Pedro Romero
Sent: Saturday, March 01, 2014 5:02 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Microsoft Excel Questions about formula
Hi Pedro
Thanks.
Scott
-Original Message-
From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On
Behalf Of Pedro Romero
Sent: Saturday, March 01, 2014 5:02 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft
@jaws-users.com
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 scottt.me...@verizon.net
To: jaws-users-list@jaws
To: jaws-users-list@jaws-users.com
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 scottt.me...@verizon.net
To: jaws
care.
Brian Lee
brianl...@charter.net
-Original Message-
From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On
Behalf Of Scott Meyer
Sent: Saturday, March 1, 2014 1:12 PM
To: jaws-users-list@jaws-users.com
Subject: [JAWS-Users] 2007 Microsoft Excel Questions about
] On
Behalf Of Scott Meyer
Sent: Saturday, March 01, 2014 5:42 PM
To: jaws-users-list@jaws-users.com
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
gregw...@comcast.net
To: jaws-users-list@jaws-users.com
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
Lee
Sent: Saturday, March 01, 2014 7:24 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Hello Scott,
Use the formula =sum(h2,k2,l2)
There should be no spacing in the formula. You had a space after h2. A
comma follows h2 and k2
] On
Behalf Of Brian Lee
Sent: Saturday, March 01, 2014 7:24 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Hello Scott,
Use the formula =sum(h2,k2,l2)
There should be no spacing in the formula. You had a space after h2. A
comma
-users.com] On
Behalf Of Brian Lee
Sent: Saturday, March 01, 2014 7:24 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Hello Scott,
Use the formula =sum(h2,k2,l2)
There should be no spacing in the formula. You had a space after h2. A
comma
, 2014 7:15 PM
To: jaws-users-list@jaws-users.com
Subject: Re: [JAWS-Users] 2007 Microsoft Excel Questions about formula
Hello Scott,
One more comment is that using CTRL+Shift+1 changes the cell formatting to
the numbering format using two decimal places.
Take care.
Brian Lee
brianl...@charter.net
18 matches
Mail list logo
