#1   Report Post  
Old December 12th 04, 09:09 PM
justamailman
 
Posts: n/a
Default average on rows

can we use average in rows even two rows at the time when number are not in
consequent collums meaning there is some spaces between them without having
to add each number manually in the function window.

--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time


  #2   Report Post  
Old December 12th 04, 09:12 PM
JE McGimpsey
 
Posts: n/a
Default

Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are not in
consequent collums meaning there is some spaces between them without having
to add each number manually in the function window.

  #3   Report Post  
Old December 12th 04, 09:29 PM
justamailman
 
Posts: n/a
Default

sorry, let me try to explain a little more . Well i have some number in two
subsequent rows in different collums and i want an average of all but the
problem is that they are not in subsequent collum. average does not seem to
work when the number have an empty collum between them

x | y | empty | z | empty | x | | | average
y | x | z | x | x | empty |

"JE McGimpsey" wrote:

Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are not in
consequent collums meaning there is some spaces between them without having
to add each number manually in the function window.


  #4   Report Post  
Old December 12th 04, 09:48 PM
Bernard Liengme
 
Posts: n/a
Default

If you used something like =AVERAGE(A1:H2) you should get the correct value
even when these are blank cell in the range. If the rows are not consecutive
you could use =AVERAGE(A1:H1, A5:H5) for example

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"justamailman" wrote in message
...
sorry, let me try to explain a little more . Well i have some number in
two
subsequent rows in different collums and i want an average of all but the
problem is that they are not in subsequent collum. average does not seem
to
work when the number have an empty collum between them

x | y | empty | z | empty | x | | |
average
y | x | z | x | x | empty |

"JE McGimpsey" wrote:

Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are
not in
consequent collums meaning there is some spaces between them without
having
to add each number manually in the function window.




  #5   Report Post  
Old December 12th 04, 09:49 PM
CLR
 
Posts: n/a
Default

Hold down Ctrl key and left-click on each of the cells you wish to
average.......then Insert Name Define and type a RangeName for your new
Non-contiguious range, say "AverageRange"

then use =AVERAGE(AverageRange)

This way, even if numbers get put in the empty cells later, it will not
affect your calculation.

Vaya con Dios,
Chuck, CABGx3


"justamailman" wrote in message
...
sorry, let me try to explain a little more . Well i have some number in

two
subsequent rows in different collums and i want an average of all but the
problem is that they are not in subsequent collum. average does not seem

to
work when the number have an empty collum between them

x | y | empty | z | empty | x | | |

average
y | x | z | x | x | empty |

"JE McGimpsey" wrote:

Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are

not in
consequent collums meaning there is some spaces between them without

having
to add each number manually in the function window.






  #6   Report Post  
Old December 13th 04, 01:51 AM
justamailman
 
Posts: n/a
Default

true it does work, thanks


"Bernard Liengme" wrote:

If you used something like =AVERAGE(A1:H2) you should get the correct value
even when these are blank cell in the range. If the rows are not consecutive
you could use =AVERAGE(A1:H1, A5:H5) for example

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"justamailman" wrote in message
...
sorry, let me try to explain a little more . Well i have some number in
two
subsequent rows in different collums and i want an average of all but the
problem is that they are not in subsequent collum. average does not seem
to
work when the number have an empty collum between them

x | y | empty | z | empty | x | | |
average
y | x | z | x | x | empty |

"JE McGimpsey" wrote:

Have you tried? Your description is confusing to me, but AVERAGE()
ignores blank cells and text...

In article ,
justamailman wrote:

can we use average in rows even two rows at the time when number are
not in
consequent collums meaning there is some spaces between them without
having
to add each number manually in the function window.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 06:00 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Blank Rows Acesmith Excel Discussion (Misc queries) 1 November 30th 04 09:23 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 29th 04 11:56 PM


All times are GMT +1. The time now is 11:37 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017