Excel Guides

DSUM Indirect References in Excel

DSUM is a function in Excel that allows you to sum the values in a range of cells based on one or more criteria. You can use DSUM to sum cells that meet certain criteria, such as cells that contain a certain value or that are in a certain range. You can also use DSUM to sum cells based on an indirect reference, which is a reference to a cell or range of cells that contains the criteria for the sum. For example, if you have a range of cells that contain values and you want to sum only the cells that contain a certain value, you can use an indirect reference to the cell that contains that value. To do this, you would enter the following formula in the cell where you want the sum:

=DSUM(range,criteria)

Where "range" is the range of cells to be summed, and "criteria" is the cell or range of cells that contains the criterion for the sum. In this example, the criterion is the value in the cell. You can also use multiple criteria by separating them with commas. For example, if you want to sum only the cells that contain a certain value and are in a certain range, you would enter the following formula:

=DSUM(range,criteria1,criteria2)

Where "range" is the range of cells to be summed, "criteria1" is the cell or range of cells that contains the first criterion for the sum (the value), and "criteria2" is

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.