# Re: DSUM function

I tried that and got a #NAME error. I sent another response to the guy who
answered me before with more detail in it. Maybe if you look at that post it

--
Too old to be in college

"Debra Dalgleish" wrote:

The DSUM structure is:
=DSUM(table_location,column_to_sum,criteria_range)

The first argument in your DSUM formula should give the location of the
entire table where the data is stored, not just the column you're trying
to sum.
If the table is on the Employee Data sheet, starts in cell A6 and ends
in cell E109, the table's range would be: 'Employee Data'!A6:E109

The second argument in the DSUM formula should give the heading or
number of the column that you want to sum. Since you want to sum the
amounts in column E, you could enter a 5 for that part of the formula.

The third argument gives the location where you have entered a heading
and the criteria for which rows to sum. Perhaps column C has the heading
Vac Days, and you want to sum the records which have 17 vacation days.
To create a criteria range, go to cell D3 on the Employee Data sheet,
and type Vac Days.
In cell D4, type the number of days vacation: 17
In your DSUM formula, you'll refer to cells D3 and D4, which is the
criteria range.

=DSUM('Employee Data'!\$A\$6:\$E\$109,5,'Employee Data'!D3:D4)

Kimmer wrote:
can not get it to work. I have tried every formula I can figure out. I even
went to the library for the Excel 2003 for Dummies book and they dont even
this figured out without getting #VALUE error or just a 0 or more than what
the total should be I would be home free and be able to finish this class.

Thanks.

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

.

## Relevant Pages

• Re: DSUM function
... The first argument in your DSUM formula should give the location of the entire table where the data is stored, not just the column you're trying to sum. ... If the table is on the Employee Data sheet, starts in cell A6 and ends in cell E109, the table's range would be: 'Employee Data'!A6:E109 ... To create a criteria range, go to cell D3 on the Employee Data sheet, and type Vac Days. ...
(microsoft.public.excel.newusers)
• Criteria Range result plus x amt of cells
... I would like to use each true criteria range result as a reference to find ... contents found in cell C17. ... will be 7 cells above the amount required for SUM? ...
(microsoft.public.excel.worksheet.functions)
• Re: Criteria Range result plus x amt of cells
... Try, in any cell other than in col C, say in D2: ... "Elaine" wrote: ... will be 7 cells above the amount required for SUM? ... results of the criteria range and criteria formula as a base location to find ...
(microsoft.public.excel.worksheet.functions)
• RE: Criteria Range result plus x amt of cells
... contents found in cell C17. ... The cell resulting in "true" from the criteria ... will be 7 cells above the amount required for SUM? ... results of the criteria range and criteria formula as a base location to find ...
(microsoft.public.excel.worksheet.functions)
• Re: Table Formula =SUM(ABOVE) give incorrect result when there is
... whenever there is only one row to sum in ANY part. ... to sum the columns above the merged cell. ... This template always work correctly for me except in cases when there is ... Below each Part there is a row for Sub Total Part-X, ...
(microsoft.public.word.tables)