Page 640 - Excel 2013 All-in-One For Dummies

622 External Data Query
Figure 2-8:
Using the DSUM to total the salaries over $55,000 in the Employee data list.
This DSUM function computes the total of all the salaries in the data list that are above $55,000. This total is $468,500, as shown in cell C2, which contains the formula.
To perform this calculation, I specified the range A3:J35, which contains the entire data list. This range includes the top row of field names as the database argument (which Excel 2013 automatically converted to its range name equiva- lent, Table2[#All]). I then specified “Salary” as the field argument of the DSUM function because this is the name of the field that contains the values that I want totaled. Finally, I specified the range E1:E2 as the criteria argument of the DSUM function because these two cells contain the criteria range that desig- nate that only the values exceeding 55000 in the Salary field are to be summed.
External Data Query
Excel makes it possible to query other external databases to which you have access and then extract the data that interests you into your worksheet
for further manipulation and analysis. Excel 2013 makes it easy to acquire data from a variety of different data sources, including Microsoft Access database files, web pages on the Internet, text files, and other data sources such as database tables on SQL Servers and Analysis Services, XML data files, and data tables from online connections to Microsoft Windows Azure DataMarket and OData Data feeds.