Mock AVERAGEIF statement not working
 

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

Mock AVERAGEIF statement not working
 

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
"SMac" wrote in message
...
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

Mock AVERAGEIF statement not working
 

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

Thanks.

"JulieD" wrote:

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
"SMac" wrote in message
...
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

Mock AVERAGEIF statement not working
 

GOT IT!!
THANKS!!

"JulieD" wrote:

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
"SMac" wrote in message
...
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

Mock AVERAGEIF statement not working
 

i'm glad :) thanks for the feedback
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"SMac" wrote in message
...
GOT IT!!
THANKS!!

"JulieD" wrote:

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
"SMac" wrote in message
...
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