Brad,

The formula should look something like this:
=AVERAGE(sheet_one!C3:C100)

If there are NO numbers in any of the cells within the
range, then you are performing division by zero.  There
has to be at least one numerical entry for the average function
to work correctly.

By the way, there is no need to select 100 rows of "future use" cells.
Just include the first blank row below the existing data when you
create the range for the average function.  The next time you need to
add more data, go to that first blank row and INSERT ROW.  Your
range will automatically expand to include the newly inserted rows.

Jim Meagher
----- Original Message -----
From: "Brad Loomis" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, August 09, 2000 9:53 AM
Subject: Re: [PCSOFT] re How do I do this in Excel?? I'm Stuck


> To produce averages from a range of data (miles, gallons etc.)  on
> one sheet to appear on a second sheet.
>
> Click in the cell where you want the average to appear, type
> =AVERAGE(
> then with your mouse click on the first sheet and highlight the
> range of data you want averaged, including plenty of blank cells for
> future data. Tap return then type the closing bracket   )  to the
> average function and it should work.
>
> Regards
> Tony
> (Tony Beckett, Rutland, UK)
>
> Hi Tony and Jim,
> I Tried  "Consolidate" from the data menu, and since I am unable to figure
> out the proper way to enter the references to the cells, I went to Tony's
> method. What happens is on my second worksheet, I have a row named Average
> Miles Driven in A1. I highlight A2, go to the formula bar, enter
> =Average(       go to the first sheet, highlight C3 through C100 (just to
> have a range of cells even though there are only 16 entries) the
> highlighting makes the for lack of a better description, blinking
highlight
> box around the range, I go back to sheet2, that range is automatically
> entered in the formula bar, I add the closing ) and in A2 cell I get the
> error, #DIV/0!   What am I missing. Obviously if I can get one done I can
do
> all the other entries I have on sheet 2.
> A Pivot table looks way to complicated for me at this time or maybe any
> other time for that matter....:)
>
> Thanks for the help.
> Brad Loomis
>
>              Do you want to signoff PCSOFT or just change to
>                     Digest mode - visit our web site:
>                     http://nospin.com/pc/pcsoft.html
>

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                    http://nospin.com/pc/pcsoft.html