Hi there,

Thanks for replying to my post – its much appreciated.

I’m sorry if I was unclear in my description of the problem I’m having. It’s a DSUM function I’m learning at the moment. It has 3 arguments: database,field,criteria.

I’ve got a table of data with headers. I’ve copied and pasted the headers into another section of the worksheet with blank rows below to enter my criteria.

There are 7 fields in my table i.e. Order Date; Region; Rep; Item; Units; Unit Cost; Revenue.

I’ve created a text box labelled DSUM and the cell next to it is where I have my DSUM formula entered. I’ve managed to work out how to calculate other questions e.g. calculate total revenue for the region ‘Central’ but only for the item ‘Pen’.
I enter ‘Central’ below the Region heading in the Criteria Section and ‘Pen’ below the Item heading and arrive at the correct result.

What I’m having difficulty with is how and where to enter from 18th October 2014 to 17th October 2015. I presume it needs to read something along the lines of: >=18/10/2014 and <=17/10/2015? As I’m entering two dates in one box under Order Date in the Criteria Section, I’m not sure how I should type this?

I hope I’ve explained this a little better? Thanks