Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work Rota - Do I need a formula? | Excel Discussion (Misc queries) | |||
Converting Date to Work Week... | Excel Discussion (Misc queries) | |||
Visible rows and functions that work | Excel Worksheet Functions | |||
Tab key don't work in unprotected cells in a protected sheet | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |