Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averageif is not working | Excel Worksheet Functions | |||
Help with Averageif Formula (don't think I should use Averageif) | Excel Discussion (Misc queries) | |||
Adding Date Range to Averageif statement | Excel Discussion (Misc queries) | |||
AverageIF with cell refenrence as criteria is not working | Excel Discussion (Misc queries) | |||
IF statement not working | Excel Discussion (Misc queries) |