software

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 lt;=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: 'lt;=D2' I
originally thought that might be the tricky part.

Thanks in advance.

DEI

Try something like this, instead of DSUM:

=SUMIF(B5:B15,quot;lt;=quot;amp;A75,C5:C15)

Does that help?

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

XL2002, WinXP-Proquot;DEIquot; wrote:

gt; This is driving me nuts, because is seems fairly simple, and I have gotten
gt; Dsum functions to work before...
gt;
gt; The database criteria is a list with (2) columns, and i include the column
gt; headings. One column is days of the month (1,2,3,4,5,etc.) all the way to
gt; 31. The second column is total charges for that day.
gt;
gt;
gt; 5 B C
gt; 5 Date Total Charges
gt; 6 1 -
gt; 7 2 -
gt; 8 3 467,981
gt; 9 4 1,065,528
gt; 10 5 1,238,425
gt; 11 6 422,813
gt; 12 7 444,759
gt; 13 8 17,777
gt; 14 9 467,611
gt; 15 10 1,768,842
gt;
gt; I want to add a Dsum function to a cell that sums total charges for the
gt; month through a day specified (Ex day 5). Here is the criteria range:
gt;
gt; A
gt; 74 Date
gt; 75 lt;=8
gt;
gt; So the function I use is: =DSUM(B5:C15,2,A74:A75)
gt;
gt; I do not get an error, it just produces a zero. If I just use an '8' as a
gt; critera without the lesser than and equals sign, it totals all the charges
gt; (all of column C) in the range. I have played with this, and if I expand the
gt; range and use a different criteria, it works fine.
gt;
gt; Alos, ultimately, I want the criteria to be a formula, so the user can add
gt; the date to another cell and have the criteria change to ex: 'lt;=D2' I
gt; originally thought that might be the tricky part.
gt;
gt; Thanks in advance.
gt;
gt; DEI
gt;
gt;
gt;