Mock AVERAGEIF statement not working

[Guest]

I looked up a mock AVERAGEIF statement and this is what I have:
=AVERAGE(IF(H6:H27="*",G6:G27))

What I have pertaining to this formula is:
Column G is "Score" and Column H is the marker which I enter * if I want to
use the number to calculate i.e.:
Score Use
15.74 *
21.79
17.93 *

Where I have the statement instead of getting the average 16.835 I get
"#Value!".

Where am I going wrong?

Thanks!!
Stacey

 

[JulieD]

Hi Stacey

are you entering it with control & shift & enter rather than just enter as
it works for me.

 

[Guest]

Where do I use that? When selecting the cells? I did that.

Thanks.

 

[Guest]

GOT IT!!
THANKS!!

Hi Stacey

are you entering it with control & shift & enter rather than just enter as
it works for me.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway

 

[JulieD]

i'm glad thanks for the feedback