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

[maria]

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]",D1617)

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

 

[krcowen]

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
D1617. 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

 

[maria]

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

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
D1617. 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

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]",D1617)

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

 

[Ashish Mathur]

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

 

[krcowen]

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

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

--
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
D1617.  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

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]",D1617)
My answer has to be 91,480. I keep getting a "Value" instead off the numeral
amount

- Show quoted text -