#### excel help

Jerry hathaway

I am trying to do a formula in excel to create a average of cells. I am trying to average cells in a row that are not consecutively with each other. I am using excel 2003, windows XP, and jaws 10. Any help will be appreciated.
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20111016/d7219664/attachment.html>

Dave...

I don't know if you (or anyone) can do an average on non-consecutive cells,
unless those you want to exclude are a zero value.

Dave Carlson
Sent from my Dell Latitude E6520 using Windows 7, San Francisco Bay Area

----- Original Message -----
From: "Jerry Hathaway" <jerry.hathaway2@frontier.com>
To: "jfw lists" <jfw@lists.the-jdh.com>
Sent: Sunday, October 16, 2011 22:25
Subject: excel help

I am trying to do a formula in excel to create a average of cells. I am
trying to average cells in a row that are not consecutively with each other.
I am using excel 2003, windows XP, and jaws 10. Any help will be
appreciated.
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20111016/d7219664/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Ann Byrne

To average cells a1, a5, and c10 through c15, it would look like this:
=average(a1,a5,c10:c15)

You could go to insert function, select averatge, and type the cells into the argument field. If you do this, remember that every time you tab forward Excel adds another field. So you have to type your coordinates and then shift-tab back to okay.

At 12:25 AM 10/17/2011, you wrote:
I am trying to do a formula in excel to create a average of cells. I am trying to average cells in a row that are not consecutively with each other. I am using excel 2003, windows XP, and jaws 10. Any help will be appreciated.
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20111016/d7219664/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

Dave...

Ann,

Great tip! Didn't know about how to specify non-contiguous ranges.

Dave Carlson
Sent from my Dell Latitude E6520 using Windows 7, San Francisco Bay Area

----- Original Message -----
From: "Ann Byrne" <annakb@sbcglobal.net>
To: "The Jaws for Windows support list." <jfw@lists.the-jdh.com>
Sent: Sunday, October 16, 2011 23:27
Subject: Re: excel help

To average cells a1, a5, and c10 through c15, it would look like this:
=average(a1,a5,c10:c15)

You could go to insert function, select averatge, and type the cells
into the argument field. If you do this, remember that every time
you tab forward Excel adds another field. So you have to type your
coordinates and then shift-tab back to okay.

At 12:25 AM 10/17/2011, you wrote:
I am trying to do a formula in excel to create a average of cells. I
am trying to average cells in a row that are not consecutively with
each other. I am using excel 2003, windows XP, and jaws 10. Any help
will be appreciated.
Jerry
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.the-jdh.com/pipermail/jfw_lists.the-jdh.com/attachments/20111016/d7219664/attachment.html>
_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

_______________________________________________
Jfw mailing list
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

 1 - 4 of 4