I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

Try using

=AVERAGE(A1:G1,AU1)

Sandy


CLytle wrote:
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

It sounds like your columns H through AT aren't out of order, but rather have
been hidden.

Select Columns G and AU
Click on the "Format" Menu
Select "Column"
Select "Unhide"

Now, you should see all of your columns.

HTH,
Elkar

"CLytle" wrote:

I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G
to
AU?

If you can't see the columns from H to AT, then they are presumaby either
hidden or have zero width. If you select columns on either side (or the
whole sheet) then you can unhide and/or set the width to something visible,
then if you want to delete the columns you can.
--
David Biddulph

Sounds like there are hidden columns - you cannot rename columns
Select the column headers G and AU and right click - is there an Unhide
item, if so click it
Happy Thanksgiving
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G
to
AU?

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

"Elkar" wrote:

It sounds like your columns H through AT aren't out of order, but rather have
been hidden.

Select Columns G and AU
Click on the "Format" Menu
Select "Column"
Select "Unhide"

Now, you should see all of your columns.

HTH,
Elkar

"CLytle" wrote:

I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

"Sandy" wrote:

Try using

=AVERAGE(A1:G1,AU1)

Sandy


CLytle wrote:
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G to
AU?

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

"David Biddulph" wrote:

"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G
to
AU?

If you can't see the columns from H to AT, then they are presumaby either
hidden or have zero width. If you select columns on either side (or the
whole sheet) then you can unhide and/or set the width to something visible,
then if you want to delete the columns you can.
--
David Biddulph

Thanks for your help. But columns are not hidden. I am getting this file
second hand, at some point someone deleted the columns but however they did
it, the columns letters did not adjust.

"Bernard Liengme" wrote:

Sounds like there are hidden columns - you cannot rename columns
Select the column headers G and AU and right click - is there an Unhide
item, if so click it
Happy Thanksgiving
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I can't
average the row. Can I "rename" the columns so there is no break from G
to
AU?

Hi

Judging by the replies you have had, and the common response you have
given to each one, if the columns are not hidden, are you saying that
all columns are visible, but there is only data in A to G and then again
from AU to say BD

=AVERAGE(A1:BD1) will return the correct result, because Average ignores
cells which have blank values
Equally
=AVERAGE(1:1)
will give you the correct average of all cells that contain numeric data
in row 1.



--
Regards

Roger Govier


"CLytle" wrote in message
...
I have a file where the columns go from A to G then skips to AU so I
can't
average the row. Can I "rename" the columns so there is no break from
G to
AU?