Hi Peo,

I needed to put in a third element and now it works.

=AVERAGE(IF('Initial Stats'!4:40, 'Initial Stats'!4:4,"")) I needed the
[value_if_false] which is the ""

I did copy Bob's formula and it did not work. This new one worked.

Thanks, I would not have been successful without your help.

Mary

"Peo Sjoblom" wrote:

Why don't you just copy Bob's formula, btw do you really have a trailing
space in the sheet name
If not use

=AVERAGE(IF('Initial Stats'!4:40, 'Initial Stats'!4:4))

entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"MaryH" wrote in message
...

Hi Bob,

It didn't work. If I put a comma between the 4 and 0 I get a wrong
formula.

If I do not put the comma in, I have no results at all. Excell allows me
to
enter the formula without an "error" but there are no results either.

Mary