Thread: Dsum

I am trying to use DSUM to extract data from a database. Each record in the database includes a date field and an amount (money) field, and I want to be able to summate the amounts between specified dates.

In order to do this I have set two criteria for the DSUM function - the earliest and latest dates to be extracted. This works fine if the dates a fixed within the criteria cells, but I want to set criteria of the form Date>$A$1, Date<$A$2 to allow dates to be specified elsewhere on the worksheet. DSUM seems happy to accept Date=$A$1 but does not work with > or <. Can anyone suggest a way of doing this?

Thanks

Rob

Sorry - should have looked at previous posts more carefully before posting! Answer available from Palmetto on the worksheet functions forum - download at http://www.excelforum.com/attachment...-condition.xls

Does my head in how obtuse some of the Excel syntax works -use
=">="&A1 to set A1 as the criteria for DSUM.

Rob