Excel Worksheet

I am working on summarizing table data in a worksheet for Excel 2007. I could really use some help as why I am having problems summarizing the annual salary for my data. Enclosed I have sent you an attachment of my worksheet so you can see what I am trying to do. The function that I am using is =DAVERAGE.
=DAVERAGE(Table2[#All],"Table2[Annual Salary]Salary]]
Salary]",D16:D17)

I keep getting the Value instead of the numeral amount of 91,480. What am I doing wrong?
Maria

▶ Reply to This

Replies to This Discussion

Permalink Reply by Shtanto on June 2, 2009 at 4:02pm: Are you pasting formulas or values or numbers? Or are you pasting at all?; ▶ Reply to This

Permalink Reply by Maria Adams on June 2, 2009 at 5:48pm

Please take a look at the attachment

Attachments:

Salary Summary.xlsx, 20 KB

▶ Reply to This

Permalink Reply by Maria Adams on June 2, 2009 at 5:57pm: My instructions say this:
You want to enter a database function to average the annual salaries by branch, using the NY branch as the initial criterion. In cell E17, use the DAVERAGE function and click the top left corner of cell A1 twice to select the table and its header row as the Database, select cell G1 for the Field and select the range D16:D17 for the Criteria.
Test the function further by entering the text Philadelphia in cell D17. When the criterion is entered, cell E17 should display 91480.
Format cell E17 in Accounting format with no decimal places and the $ symbol.; ▶ Reply to This