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/
