A
Alexander
Hi
An easy question for someone who knows a bit about the dcount formula.
I really need some help with dcount or a similar 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 something that looks like this:
A B C D
E
1 Day Date Time Maureen John
2 Mon 01-Sep e-learning e-learning e-learning
3 08:00 - 11:00 Other Sales
4 11:00 - 14:00 Other Sales
5 14:00 - 17:00 Other Sales
6 Tue 02-Sep e-learning e-learning e-learning
7 08:00 - 11:00 Other Sales
8 11:00 - 14:00 Other Sales
14:00 - 17:00 Other Sales
Cells A2:A5 are merged, as well as B2:B5. (This may impact the formula
required)
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.
Any ideas on how I can do this across all the 5 sheets?
Many Thanks
Alex
An easy question for someone who knows a bit about the dcount formula.
I really need some help with dcount or a similar 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 something that looks like this:
A B C D
E
1 Day Date Time Maureen John
2 Mon 01-Sep e-learning e-learning e-learning
3 08:00 - 11:00 Other Sales
4 11:00 - 14:00 Other Sales
5 14:00 - 17:00 Other Sales
6 Tue 02-Sep e-learning e-learning e-learning
7 08:00 - 11:00 Other Sales
8 11:00 - 14:00 Other Sales
14:00 - 17:00 Other Sales
Cells A2:A5 are merged, as well as B2:B5. (This may impact the formula
required)
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.
Any ideas on how I can do this across all the 5 sheets?
Many Thanks
Alex