The Dsum function in Excel stands for “database sum” and is incredibly handy for calculating totals out of groups of data. To begin using it, the first step is to select the data and insert a table out of the data.
Once you have the table set up, you can start using Dsum to find specific data. For example, if you want to know how much Dave has sold in a given month, you can use the following steps:
1. Type “sales person” and “Dave” as your criteria.
2. Go to the function key and select Dsum.
3. Select the entire table and choose “amount” as your field.
4. Select the salesperson criteria and choose Dave.
This will give you the total sales for Dave in that month. You can also use Dsum to add up the sales figures for multiple people. For example, if you want to add up the sales for both Dave and Jen, you can follow these steps:
1. Type “sales person” and “Dave” and “Jan” as your criteria.
2. Go to the function key and select Dsum.
3. Select the entire table and choose “amount” as your field.
4. Select the salesperson criteria and choose Dave and Jan.
This will give you the total sales for both Dave and Jen.
Remember to use quotation marks when typing in your criteria, and select the entire table and appropriate fields when using the Dsum function. With these tips, you can easily calculate totals from groups of data in Excel.