Posted to microsoft.public.excel.worksheet.functions

Maria

external usenet poster

Posts: 71

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average annual GROWTH	BA	Excel Worksheet Functions	2	August 22nd 07 02:11 AM
Dynamic annual average	[email protected]	Charts and Charting in Excel	4	July 31st 06 11:49 PM
How to: average annual growth	[email protected]	Excel Worksheet Functions	3	May 3rd 06 06:47 AM
How to: average annual growth	[email protected]	Excel Worksheet Functions	0	May 2nd 06 07:11 PM
average annual return	rathersurf	Excel Worksheet Functions	1	July 22nd 05 04:48 AM

All times are GMT +1. The time now is 06:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us