Thanks Chrissy,

Tom helped me out with the formula and I've got it working now.

Eric


On Sat, 11 Oct 2003 14:19:27 +1300, "Chrissy" wrote:

The formula
= AVERAGE( range )

will return the average of the numbers in that range. It is identical to the
formula

= SUM ( range ) / COUNT ( range )

Your formula does not average anything. If I put your formula in a cell in
column C then I get results that could be obtained by

= C4/C2 * 100

If I copy that across to all cells in that row in cols C to J I get the same
results that you get. You do say that you are not getting the correct results
but do not say what is wrong or what you want.

I cannot work out why you are using AVERAGE anyway.

How about you say what values you have and what results you want and
where these values are.

What I think you have is a table with values in the top row and you want
to get results from different rows divided by the top row value - but that
it just a guess.

Chrissy.


Eric G wrote
I'd really appreciate getting some help with one formula I'm working
on, if possible.

Something like:

AVERAGE(C4:J4/C$2:J$2*100)

Right now I sort of have it working.
The only problem is that with values at the moment in only C4:E4
it's giving me a 'false' average.

I could restrict the formula to the cells that have values but it
would be very tedious to keep changing it each time I add a value to
F4, G4 etc.

TIA Eric