COUNTIF W/ Dates

[MN05]

Hey everyone,

First time poster here but I look forward to hopefully being able to contribute to the community!

I have a series of sheets (one for each employee) that track their daily tasks with the columns DATE (column A) and TASK (column B). Both DATE and TASK have drop-down menus where employees must choose from a list of items. Basically, I'm trying to count how each employee's week is split between a myriad of tasks (how many different "invoice" tasks, "ergonomic" tasks, "other" tasks, etc). Here's how it looks for Employee1:

	Date (drop-down)	Task (drop-down)
Employee1
Employee1
Employee1

I'd like to be able to output this in a 'Summary' sheet so I can run weekly reports to gauge how my work team's week has looked. The summary tab currently looks like this:

Report Date Range: [date here]

	Task 1	Task 2	Task 3	Task 4	Task 5
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5

The problem that I'm having is that when I run my formula using my "Report Date Range" control cell atop my Summary page, it is not differentiating between different dates in the Employee-specific sheet. Basically, if my Date column in the Employee-specific sheet includes the chosen date from my control cell just one time, the COUNTIF function counts all instances of specific tasks for the entire sheet, even if those tasks are linked to different dates.

I am hopeful this is a good enough explanation. I'm stumped. Help?

[cbatrody]

Hi & welcome to the Forum.

Please post a sample template of you workbook with the help of paper clip icon under "Go Advanced" option.

[MN05]

Sample Template.xlsx

Thanks cbatrody.

Please see attached.

[cbatrody]

Hi,

I have updated the formula in the attached file. However, I suggest it would be better if you update all employee details in one sheet rather than creating one tab for each. By doing this, you can easily summarize the data using pivot tables or other functions.