Dsum will not work
 

This is driving me nuts, because is seems fairly simple, and I have gotten
Dsum functions to work before...

The database criteria is a list with (2) columns, and i include the column
headings. One column is days of the month (1,2,3,4,5,etc.) all the way to
31. The second column is total charges for that day.


5 B C
5 Date Total Charges
6 1 -
7 2 -
8 3 467,981
9 4 1,065,528
10 5 1,238,425
11 6 422,813
12 7 444,759
13 8 17,777
14 9 467,611
15 10 1,768,842

I want to add a Dsum function to a cell that sums total charges for the
month through a day specified (Ex day 5). Here is the criteria range:

A
74 Date
75 <=8

So the function I use is: =DSUM(B5:C15,2,A74:A75)

I do not get an error, it just produces a zero. If I just use an '8' as a
critera without the lesser than and equals sign, it totals all the charges
(all of column C) in the range. I have played with this, and if I expand the
range and use a different criteria, it works fine.

Alos, ultimately, I want the criteria to be a formula, so the user can add
the date to another cell and have the criteria change to ex: '<=D2' I
originally thought that might be the tricky part.

Thanks in advance.

DEI

Dsum will not work
 

Try something like this, instead of DSUM:

=SUMIF(B5:B15,"<="&A75,C5:C15)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"DEI" wrote:

This is driving me nuts, because is seems fairly simple, and I have gotten
Dsum functions to work before...

The database criteria is a list with (2) columns, and i include the column
headings. One column is days of the month (1,2,3,4,5,etc.) all the way to
31. The second column is total charges for that day.


5 B C
5 Date Total Charges
6 1 -
7 2 -
8 3 467,981
9 4 1,065,528
10 5 1,238,425
11 6 422,813
12 7 444,759
13 8 17,777
14 9 467,611
15 10 1,768,842

I want to add a Dsum function to a cell that sums total charges for the
month through a day specified (Ex day 5). Here is the criteria range:

A
74 Date
75 <=8

So the function I use is: =DSUM(B5:C15,2,A74:A75)

I do not get an error, it just produces a zero. If I just use an '8' as a
critera without the lesser than and equals sign, it totals all the charges
(all of column C) in the range. I have played with this, and if I expand the
range and use a different criteria, it works fine.

Alos, ultimately, I want the criteria to be a formula, so the user can add
the date to another cell and have the criteria change to ex: '<=D2' I
originally thought that might be the tricky part.

Thanks in advance.

DEI