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