How to Use DSUM in a Continuous Form
Microsoft Excel is a component of the Microsoft Office software suite. Excel is used primarily to create spreadsheets, which display and calculate data. Some of the calculations can be quite complex and allow you to create highly useful spreadsheets. The “DSUM” function allows you to sum up all the values in a series of continuous cells as long as they satisfy a condition. For example, you can sum up all the salaries of employees who earn less than $25,000 a year using DSUM.
Other People Are Reading
Instructions
-
-
1
Click the Excel icon to launch the program. A blank spreadsheet is automatically created for you.
-
2
Fill Cell A1 with a column header, such as:
Salary < 25000
-
-
3
Fill Cell A2 with another column header, such as:
Salary > 25000
-
4
Fill in Columns A and B with arbitrary data. Simply click on a cell and enter a number. Make sure all the numbers you enter into Column A are less than 25000 and all the numbers you enter into Column B are greater than 25000. Enter eight values in each column.
-
5
Create a DSUM function using the continuous column of data you just entered. The DSUM function needs to know what rows and columns to read, which can be expressed as a beginning and ending cell. Write the following in Cell C1:
=DSUM(A1:B9,
-
6
Write the condition that must be satisfied for the DSUM function to add up values. In this case, you can sum up all the salaries that are below 25000. Continue the DSUM function by adding to what you've written in Cell C1:
=DSUM(A1:B9, "Salary < 25000",
-
7
Write the range of cells that satisfy the criteria you specified in the previous step. Conclude the DSUM function by completing the Cell C1 writing:
=DSUM(A1:B9,"Salary < 25000", A1:A9)
-
8
Press the “Enter” key to execute the DSUM function. It will add up all the salaries that are less than 25000 on your form.
-
1
References
- Photo Credit Stockbyte/Stockbyte/Getty Images
