I need to use a DAVERAGE function to determine the average annual salary.
Here is my information:
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

My answer has to be 91,480. I keep getting a "Value" instead off the numeral
amount
--
Maria A Adams

Maria

I assume since you "need to use" a DAVERAGE function that you are
averaging a subset of your data that meets a certain criteria. In
that case the data should be in Table2 and the criteria should be in
D16:D17. The middle argument should be a field which should be a
number indicating the column of your data that is averaged if the
criteria is met. It appears that your second argument may not be a
suitable way to indicate the field.

Good luck.

Ken
Norfolk, Va


On May 28, 12:36*pm, maria wrote:
I need to use a DAVERAGE function to determine the average annual salary.
Here is my information:
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

My answer has to be 91,480. I keep getting a "Value" instead off the numeral
amount
--
Maria A Adams

According to help this is the formula that it tells me to use. What would use
in place of the "Annual Salary"?

--
Maria A Adams


" wrote:

Maria

I assume since you "need to use" a DAVERAGE function that you are
averaging a subset of your data that meets a certain criteria. In
that case the data should be in Table2 and the criteria should be in
D16:D17. The middle argument should be a field which should be a
number indicating the column of your data that is averaged if the
criteria is met. It appears that your second argument may not be a
suitable way to indicate the field.

Good luck.

Ken
Norfolk, Va


On May 28, 12:36 pm, maria wrote:
I need to use a DAVERAGE function to determine the average annual salary.
Here is my information:
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

My answer has to be 91,480. I keep getting a "Value" instead off the numeral
amount
--
Maria A Adams

Hi,

You should not have the quotes around the second argument. Also check that
the heading of the criteria and the range are the same

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"maria" wrote in message
...
I need to use a DAVERAGE function to determine the average annual salary.
Here is my information:
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

My answer has to be 91,480. I keep getting a "Value" instead off the
numeral
amount
--
Maria A Adams

The column number from Table 2 that you want to average for records
that match the criteria in D16:D17



On May 28, 2:26*pm, maria wrote:
According to help this is the formula that it tells me to use. What would use
in place of the "Annual Salary"?

--
Maria A Adams



" wrote:
Maria

I assume since you "need to use" a DAVERAGE function that you are
averaging a subset of your data that meets a certain criteria. *In
that case the data should be in Table2 and the criteria should be in
D16:D17. *The middle argument should be a field which should be a
number indicating the column of your data that is averaged if the
criteria is met. *It appears that your second argument may not be a
suitable way to indicate the field.

Good luck.

Ken
Norfolk, Va

On May 28, 12:36 pm, maria wrote:
I need to use a DAVERAGE function to determine the average annual salary.
Here is my information:
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

My answer has to be 91,480. I keep getting a "Value" instead off the numeral
amount
--
Maria A Adams- Hide quoted text -

- Show quoted text -