How to enter a database function to average the annual salary?
 

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

How to enter a database function to average the annual salary?
 

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

How to enter a database function to average the annual salary?
 

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

How to enter a database function to average the annual salary?
 

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

How to enter a database function to average the annual salary?
 

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 -