Technical Lookup & DCount Query

**Alexander_Read** · 09-05-2008, 04:36 AM

Hi

I really need some help with a function that can do this:

I have 5 seperate sheets in 1 workbook, each with a week of the month and a spare week. I.e. Week 1, Week 2, Week 3, Week 4, Week 5.

Thus, in Week 1 I have a table that looks like this: (see attachment) (when I import it into this format, it shuffles all the columns which is why I have put it as an attachment.

Example.zip

Some cells are merged.

Sheets for weeks 2,3,4,5 are the same, they just have different dates.
(i.e. instead of having 1 Sep & 2 Sep, they have 10 Sep & 11 Sep, etc.)

What I want to do is count the number of times "John" does "Sales" after a
specific date but before the next date. I.e. in this example how many times
does "John" do "Sales" from the and including 2 Sep 08 but before 1 Oct 08?
I.e. the answer needs to be 3.

Firstly, how do i do this with one sheet?
Secondly, how do I do the formula to do it across 5 different sheets?

Any help would be appreciated!

Many Thanks

Alex

**Alexander40** · 09-05-2008, 11:35 AM

Playing around with date functions can easily give you a headache. You can try the attached solution.

**Alexander_Read** · 09-08-2008, 03:24 AM

Hi

Thanks for the reponse.

That should be able to work:

1) How do I combine it with another variable? i.e. to only count "sales" between a date range.
2) How do I do it to include merged cells?

Regards

Alex

**Alexander_Read** · 09-08-2008, 04:46 AM

Can a moderator please close this thread. I opened two threads by mistake.
It is open elsewhere. (http://www.excelforum.com/excel-work...ml#post1965013)

Sorry and many thanks.