DSUM: Office/Date Table Not Summing Properly

[isadoko]

OS: XP
XL: 2003

This is my first time using DSUM. I have crafted this formula:

=DSUM('B385 Ledger'!A:C,"Amount",'B385 Open Balance'!X1:Y171)

My data table is set up thus (dates range 12/30/04 to 1/20/05):

Office No Date Amount
2 12/30/04 (1,088.00)
3 12/30/04 (169.00)
6 12/30/04 703.00
8 12/30/04 (66.00)
9 12/30/04 (324.29)

My "results" table looks thus (dates range 12/30/04 to 1/20/05):
Office No Date
1 >=12/1/04
1 <=12/31/04
2 >=12/1/04
2 <=12/31/04
3 >=12/1/04
3 <=12/31/04

Naturally I have a cell containing the DSUM formula (result).

I understand DSUM to read the headings ("office No" and "Date") and the data below to calculate: not so...thus far. It seems unable to interpret the date bands (>=12/1/04 to <=12/31/04)assigned to each office number. I was told I needed "start" and "end" dates to limit my search with corresponding office numbers.

My sample holds in part 22 offices, all dated 12/30/04. The balance of 60 offices all show January 2005 dates. The rub is my formula is summing the December entries though my date band is >=1/1/2005 to <=1/31/2005.

As this table will grow throughout 2005 I want to sum up each office's monthly total. I had in mind a table with column of office numbers and rows of months.

What am I doing wrong? I look forward to your response and many thanks.

 

[Scott R]

If you want dates between 12/1 and 12/31, you can't stack the criteria because that would mean 'or'; it has to be side-by-side for 'and'.

Office Date Date
1 >=12/1/04 <=12/31/04